ExcelBanter - FILTER OUT DATES IN LIST

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - FILTER OUT DATES IN LIST (https://www.excelbanter.com/excel-worksheet-functions/10760-filter-out-dates-list.html)

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

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