| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to get largest date from a Vlookup
I have following data amongst other columns.
Product Date aaa 2014-02-11 aaa 2014-02-12 aaa 2014-02-03 aaa 2014-01-22 bbb 2013-01-17 bbb 2014-01-23 bbb 2014-01-28 bbb 2014-01-06 bbb 2013-01-28 In another sheet, I need to search product and get the largest date against that product. Formula result required is as below. aaa 2014-02-12 bbb 2014-01-28 Kindly help. Madiya |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| What is a formula for finding the largest date in a list of dates? | Excel Discussion (Misc queries) | |||
| Searching for the largest value | Excel Discussion (Misc queries) | |||
| Find 2nd Largest Value | Excel Worksheet Functions | |||
| Largest Value | Excel Worksheet Functions | |||
| Second largest value | Excel Discussion (Misc queries) | |||
Threaded Mode
