| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
VLOOKUP and Return Last 2 Values
Here is an example table...
Date | Name | Score | 5/20/2009 | Nick | 95 | 5/21/2009 | Jon | 96 | 5/22/2009 | Jon | 97 | 5/23/2009 | Jon | 98 | 5/24/2009 | Jon | 99 | 5/25/2009 | Nick | 72 | 5/26/2009 | Jon | 45 | 5/27/2009 | Nick | 30 | I would like to create a summary page that has "Nick" and "Jon" and returns their last 2 most recent scores to track their current trend. So for Nick, the result would be: Nick Most Recent: 30 Second Most Recent: 72 Jon Most Recent: 45 Second Most Recent: 99 There will never be duplicate dates. The primary key is basically the date column. I will continue to add dates on the data dump table so it will need to have the opportunity to expand. I've searched through this for a while and can't find my answer. Any help is greatly appreciated! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Using H/VLOOKUP to return multiple values | Excel Discussion (Misc queries) | |||
| Vlookup Return Multiple Values | Excel Discussion (Misc queries) | |||
| How do I return Multiple values using VLookup? | Excel Worksheet Functions | |||
| vlookup one value and return multiple values | Excel Discussion (Misc queries) | |||
| vlookup function return all values | Excel Worksheet Functions | |||
Threaded Mode
