| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Latest LOOKup
Dear All,
I have the following data: A Units abc 30 xyz 20 abc 10 xyz 40 abc 50 I want to know the latest units used by abc, i also want to know the minimum units used by abc. Anybody can help me. Thnx |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Latest LOOKup
Maybe try these two. Use Ctrl+Shift+Enter to enter the second:
=LOOKUP(2,1/(A2:A100="abc"),B2:B100) =MIN((A2:A100="abc")*B2:B100) "shaqil" wrote: Dear All, I have the following data: A Units abc 30 xyz 20 abc 10 xyz 40 abc 50 I want to know the latest units used by abc, i also want to know the minimum units used by abc. Anybody can help me. Thnx |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| latest date | New Users to Excel | |||
| Lookup / return latest date in range AND value of 1 column to the | Excel Worksheet Functions | |||
| lookup latest entered match | Excel Worksheet Functions | |||
| latest entry | Excel Worksheet Functions | |||
| Lookup the latest date in a range so it appears as my result | Excel Discussion (Misc queries) | |||
Linear Mode
