P
Pantryman
Who knows how I can lookup the LAST match in a column?
i.e., in A1:A1000 there's 1000 names, unsorted, with multiple name
repeated.
If I want to find the last mention of 'Bob' and then get the value o
the cell next to it, how can I do that?
The first match is no problem, but I can't figure out the last.
Thanks muchly,
Marinus
i.e., in A1:A1000 there's 1000 names, unsorted, with multiple name
repeated.
If I want to find the last mention of 'Bob' and then get the value o
the cell next to it, how can I do that?
The first match is no problem, but I can't figure out the last.
Thanks muchly,
Marinus