| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sort list
Hi! I have a long list of dates. Some of these dates occur many times in the
list (it is however in date order). I want to clean that list so that I have a list containing only unique dates. In other words I just want to have one occurrence of each date. How can I do this? Please help me! Many thanks in advance! |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Sort list
Use Data Data, Advanced Filter...
Steve On Thu, 25 Jan 2007 07:56:02 -0000, Arne Hegefors wrote: Hi! I have a long list of dates. Some of these dates occur many times in the list (it is however in date order). I want to clean that list so that I have a list containing only unique dates. In other words I just want to have one occurrence of each date. How can I do this? Please help me! Many thanks in advance! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| When I sort a list, How can I keep blank rows between the fields? | Excel Discussion (Misc queries) | |||
| When I sort a list, How can I keep blank rows between the fields? | Excel Discussion (Misc queries) | |||
| Sort a list with uneven row information | Excel Worksheet Functions | |||
| Sort with a List | Excel Worksheet Functions | |||
| How do I sort a list of dates in Excel by month and day? | Excel Discussion (Misc queries) | |||
Linear Mode
