| Home |
| Search |
| Today's Posts |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Filtering out old records.
I would "SORT" by DATE - then Copy and paste the "unwanted" into a new sheet in case you want to review it later, then delete the original. You can also filter using "equal to or greater than" then enter you date of the the items you no longer want - then select, copy and paste into an new sheet as required, - then delet from the original. -- wjohnson ------------------------------------------------------------------------ wjohnson's Profile: http://www.excelforum.com/member.php...o&userid=29640 View this thread: http://www.excelforum.com/showthread...hreadid=526068 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Filtering Records | Excel Worksheet Functions | |||
| Top 90% of records - Bring out number | Excel Discussion (Misc queries) | |||
| Advanced filtering in Excel to find records ending in xxx? | Excel Discussion (Misc queries) | |||
| filtering for unique records | Excel Discussion (Misc queries) | |||
| Deleting specific records | Excel Discussion (Misc queries) | |||
Threaded Mode
