FILTER OUT DATES IN LIST

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Custom auto filter (Dates) 2
A function for filtering between Dates 4
Problem formatting dates from CSV file 2
Pivot table macro filter data between yesterday and today (date+time) 0
Filter Customize date 3
Date lists 3
Sum value between two dates and copy to new cell 6
Advanced Filters 9

Back
Top