| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sorting and Deleting Help
Good Day,
I have 3653 rows of data which have the following information by column; ItemNumber Quantity Date PRN223 56 02012003 PRN223 44 01042004 PRN223 41 06052003 PRN223 36 11272006 PRN223 49 08221999 What I need to do is first find the last time there was activity on the item number, the example above would be the 11272006 date as the last activity, I then want to purge all the other rows except the one record. I have 562 different item numbers total. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Deleting cell data without deleting formula | Excel Discussion (Misc queries) | |||
| Deleting data by sorting dates | Excel Discussion (Misc queries) | |||
| Sorting and deleting empty cells | Excel Discussion (Misc queries) | |||
| deleting values in a worksheet without deleting the formulas | Excel Worksheet Functions | |||
| how prevent formula in cell from deleting when deleting value???? | New Users to Excel | |||
Threaded Mode
