G
Guest
Problem is to find max Row() number for a value in column. Lets imagine that
you have column like this:
A1: 1
A2: 2
A3: 100
A4: 1
A5: 1
A6: 100
A7: 3
What I need is to get max Row() for value (100 in this example) without
using VBA. (So in my example it'll return 6.)
Thanks to all in advance !
Vlado
you have column like this:
A1: 1
A2: 2
A3: 100
A4: 1
A5: 1
A6: 100
A7: 3
What I need is to get max Row() for value (100 in this example) without
using VBA. (So in my example it'll return 6.)
Thanks to all in advance !
Vlado