| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
FILTER OUT DATES IN LIST
I have a list in a column, including various comments and dates in 31/01/05
format. How can I apply a filter so I see everything EXCEPT the dates? i.e. if i go to <custom filter <does not equal <Date...but that that obviously doesn't work Any suggestions? Thanks Lisa |
|
#2
|
|||
|
|||
|
In the AutoFilter dropdown for that column, select Custom
In the first dropdown, choose 'greater than or equal to' In the text box, type: a Click OK Lisa wrote: I have a list in a column, including various comments and dates in 31/01/05 format. How can I apply a filter so I see everything EXCEPT the dates? i.e. if i go to <custom filter <does not equal <Date...but that that obviously doesn't work Any suggestions? Thanks Lisa -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Extracting Values on one list and not another | Excel Discussion (Misc queries) | |||
| have dates entered from a list of data into an excel template | Excel Discussion (Misc queries) | |||
| How can i filter dates based on day of month | Excel Worksheet Functions | |||
| Excel Auto Filter: WHY'S SORT @ TOP OF LIST? WHEN I KEY TO "SHOW . | Excel Worksheet Functions | |||
| I have a list of dates that I need to count based on a date range | Excel Worksheet Functions | |||
Hybrid Mode
