Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
vlookup function that returns the greates/oldest of many to one
Column A is a list of user names that repeat many times. Column B is a list
dates corresponding to the names that repeat in column A. Column D is a list of Active user names that do not repeat. I need to look up the Active user name in Column D from Column A in order to return the greatest/most recent date from column B. Example of existing data: User Name Date Active User Name JohnDoe 03/20/09 JohnDoe JohnDoe 02/20/09 JaneDoe JohnDoe 01/20/09 MargeLoe JohnDoe 12/20/08 DonRoe JohnDoe 11/20/09 PhilWoe Example of search results: User Name Date Active User Name JohnDoe 03/20/09 JohnDoe |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Vlookup function returns duplicate values | Excel Discussion (Misc queries) | |||
vlookup returns #n/a | Excel Worksheet Functions | |||
VLOOKUP returns #REF!? | Excel Discussion (Misc queries) | |||
How do I write a VLOOKUP function that returns 0's, not neg vals? | Excel Worksheet Functions | |||
VLOOKUP Returns #REF | Excel Worksheet Functions |