Return ALL relative positions of a value within an array

[bekaii]

I am looking for a way to return ALL relative positions of a value within an array. The 'match' formula allows to determine the first position of that value...but I need to determine the row number of all the instances of the value.

Can anyone help. Thank you so much!

[rylo]

Hi

Perhaps build your own function (UDF).

In a general module in the relevant workbook, put in the code

Please Login or Register  to view this content.

Say your data was in the range A2:A9, and contained some "a" values. Enter the function
=getpos(A2:A9,"a")
and it will return the row numbers of the relevant matches.

HTH

rylo