| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Select last record for each account
Hi all,
I have an excel file with the following format: Account Date Amount 00110 1/20/2005 120.51 00110 6/2/2005 87.01 00110 8/15/2005 255.09 02055 2/5/2005 70.05 02055 4/1/2005 192.88 15240 2/20/2005 457.18 15240 9/21/2005 19.77 .... and so on. The file has 12000 entries for over 500 different accounts. I would like to select the entries for each account with the latest date. How do I do this? Thanks, Gordon |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Select last record for each account
Got it.
Use Subtotal function. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| VLOOKUP? Need to have value returned when select from drop-down list | Excel Worksheet Functions | |||
| Extracting/look up data from a list and select multiple instances | Excel Worksheet Functions | |||
| macro to eliminate repeating account numbers | New Users to Excel | |||
| Chart Account# and $ value from MANY into Line Chart | Charts and Charting in Excel | |||
| Select all data, multiple rows | Excel Discussion (Misc queries) | |||
Hybrid Mode
