Get Row number of matches within a column

[plans]

Hello,
I have a column which contains a long list of Products; The products might be listed multiple times in the column, like:
Product 1
Product 2
Product 2
Product 5
Product 5
Product 2
Product 1
Product 3
Product 6
Product 3
I need a macro which looks up say, the” Product 2” and returns a list of the Row numbers where “Product 2“ is listed.
(in this case, would look like: 2,3,6)
Could you please advise.
Thanks

[alansidman]

Assumes Data is in Column A.

Please Login or Register  to view this content.

[bakerman2]

which contains a long list of Products

In that case I would read column values into memory and work from there.

Please Login or Register  to view this content.