Hello All,
I've tried searching for my following query but had no luck so starting a new topic.
I have the following table
<tbody>
</tbody>
I want to return the above table as hyperlink in the following format
<tbody>
</tbody>
I can return it using the small, frequency and hyperlink formulae if there are only two columns but cant seem to find a way when there is a third column.
I would like to stay away from macros. Is there any way where this can be done?
Any help will be much appreciated.
I've tried searching for my following query but had no luck so starting a new topic.
I have the following table
| Col-A | Col-B | Col-C |
| A-1 | B-1 | C-1 |
| A-2 | B-2 | C-2 |
| A-2 | B-2 | C-3 |
| A-2 | B-3 | C-4 |
| A-3 | B-4 | C-5 |
| A-3 | B-5 | C-6 |
| A-4 | B-5 | C-7 |
| A-4 | B-6 | C-8 |
| A-5 | B-7 | C-9 |
| A-5 | B-8 | C-10 |
<tbody>
</tbody>
I want to return the above table as hyperlink in the following format
| Col-A | Col-B | Col-C1 | Col-C2 |
| A-1 | B-1 | C-1 | |
| A-2 | B-2 | C-2 | C-3 |
| A-2 | B-3 | C-4 | |
| A-3 | B-4 | C-5 | |
| A-3 | B-5 | C-6 | |
| A-4 | B-5 | C-7 | |
| A-4 | B-6 | C-8 | |
| A-5 | B-7 | C-9 | |
| A-5 | B-8 | C-10 |
<tbody>
</tbody>
I can return it using the small, frequency and hyperlink formulae if there are only two columns but cant seem to find a way when there is a third column.
I would like to stay away from macros. Is there any way where this can be done?
Any help will be much appreciated.
