Match: Find last matching row

M

mbobro

Hi,

I have one column sorted where are different values. In order to fin
the row of matching value of my interest I use match function that i
perfect here. Almost perfect....

The trouble is match gives me first row where it accounters give
value. Unfortunately I need to find the smallest number, so I may no
say what exactly number I'm searching for and as a result use match.

I need to add that there are some strings and numbers in the column, s
when I sort it strings are separated from values and values are sorte
as asked. So if I knew function that wil
'match_the_last_string_value_in _the_column' that would solve th
issue.


Thanks,


Michal Bobrowsk
 
F

Frank Kabel

Hi
so you're searching for the smallest string? Could you post some
example data (plain text - no attachments please)
 
B

Biff

Hi!

So, you want to find the position of the last string in
the column?

=MATCH(REPT("Z",255),A:A)

Biff
 
Top