| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Finding latest match in range
Hi:
I have abc 0 abc 10 abc 20 abc 30 efg 0 efg 10 abc -20 efg 50 How can I express a formula to obtain -20 for "abc" and 50 for "efg" out of this data? My goal is to get the numeric value (B) corresponding to the highest matching row within the specified range. Thanks, IGM |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| need to return next match of table, only finding first match...HEL | Excel Worksheet Functions | |||
| Finding Latest Variable | Excel Discussion (Misc queries) | |||
| Finding the latest date represented in a group of cells | Excel Discussion (Misc queries) | |||
| lookup latest entered match | Excel Worksheet Functions | |||
| Finding the Latest Date from Several Dates in Different Columns | Excel Discussion (Misc queries) | |||
Threaded Mode
