C cgreen Active Member Joined Aug 14, 2002 Messages 290 Nov 21, 2005 #1 I would like to create an auto filter in a column to only show me cells that do not have a date. So all I want to see is blank cells and cells with text in them. How do I do that??
I would like to create an auto filter in a column to only show me cells that do not have a date. So all I want to see is blank cells and cells with text in them. How do I do that??
B BrianB Well-known Member Joined Feb 17, 2003 Messages 8,127 Nov 21, 2005 #2 Another column I think with a formula like :- =IF(OR(ISBLANK(A1),ISTEXT(A1)),"Yes","No")
C cgreen Active Member Joined Aug 14, 2002 Messages 290 Nov 21, 2005 #3 Thank you Brian, that worked prefect!!