Hi All,
Below is an extract of a table of data I currently have which in reality is much larger with 54 risks and 90 funds across the top.
<tbody>
</tbody>
I need to replace the X's with the risk number which I can do by using the mid function but as the table is so large is there a quick way of doing this in VBA instead of filtering by each fund and copying the formula down.
Also I need to concatenate the risk numbers to send to our developers with a comma in-between as shown in the example result for Funds A & B.
Thanks in advance!
Below is an extract of a table of data I currently have which in reality is much larger with 54 risks and 90 funds across the top.
Fund A | Fund B | Fund C | Fund D | Fund E | |
Risk_01_RT | X | X | X | X | X |
Risk_02_RT | X | X | |||
Risk_03_RT | X | ||||
Risk_04_RT | X | X | X | ||
Risk_05_RT | X | X | X | X | |
Result | 01,03,05 | 01,02,04 |
<tbody>
</tbody>
I need to replace the X's with the risk number which I can do by using the mid function but as the table is so large is there a quick way of doing this in VBA instead of filtering by each fund and copying the formula down.
Also I need to concatenate the risk numbers to send to our developers with a comma in-between as shown in the example result for Funds A & B.
Thanks in advance!