| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sort by last update only - get rid of old ones
I have a very large worksheet that has multiple SKU's sorted by SKU then
Edition. I would like to get rid of the old Editions and just keep the current one. On the exampe below, SKU 10E01254 has 3 editions I want to get rid of 1 and 2 and keep the 3rd. all sku have multiple editions from 2 to 19 editions but I just one to keep on one spreadsheet the latest one on all SKU's SKU Edition Price 10E01254 01 $850.00 10E01254 02 $850.00 10E01254 03 $840.00 Keep this 12L13567 01 $725.00 12L13567 02 $725.00 12L13567 03 $725.00 12L13567 04 $760.00 12L13567 05 $950.00 Keep this 12B01781 01 $160.00 12B01781 02 $180.00 Keep this |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Move - update - sort descending | Excel Discussion (Misc queries) | |||
| Worksheet Reference Doesn't Update After Sort | Excel Worksheet Functions | |||
| i want to update one excel file the other one update automaticaly | New Users to Excel | |||
| League table automatic sort/update | New Users to Excel | |||
| How to sort/update large excel db | Excel Discussion (Misc queries) | |||
Threaded Mode
