| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
find LAST match in column
Who knows how I can lookup the LAST match in a column? i.e., in A1:A1000 there's 1000 names, unsorted, with multiple names repeated. If I want to find the last mention of 'Bob' and then get the value of 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. -- Pantryman ------------------------------------------------------------------------ Pantryman's Profile: http://www.excelforum.com/member.php...o&userid=15233 View this thread: http://www.excelforum.com/showthread...hreadid=275479 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| find rows for unique data in 1 column and different data in other. | Excel Discussion (Misc queries) | |||
| How do I find the first value in a column less than a number? | Excel Worksheet Functions | |||
| Find AVG/MIN of a Column, excluding 0's and NULL's? | Excel Worksheet Functions | |||
| find and match the max | Excel Worksheet Functions | |||
| Use MATCH to find position of max in 2D range? | Excel Worksheet Functions | |||
Threaded Mode
