Hello to all,
I have this table in range A1:C7:
<tbody>
</tbody>
- A formula that gives me a set of row numbers of all occurences of 2 in column B, result should be {3,5,7}
- and how to store that result in an VBA array to use it in a macro.
In this example, there are 3 occurences, so, the set result has 3 elements. But if there are
50 occurences, the result set should have 50 elements.
I hope is possible.
Thanks in advance for any help.
I have this table in range A1:C7:
Header1 | Header2 | Header3 |
98 | 3 | 462 |
77 | 2 | 77 |
65 | 8 | 23 |
65 | 2 | 982 |
2 | 5 | 11 |
44 | 2 | 35 |
<tbody>
</tbody>
- A formula that gives me a set of row numbers of all occurences of 2 in column B, result should be {3,5,7}
- and how to store that result in an VBA array to use it in a macro.
In this example, there are 3 occurences, so, the set result has 3 elements. But if there are
50 occurences, the result set should have 50 elements.
I hope is possible.
Thanks in advance for any help.
Last edited: