Special Auto Filter Format

cgreen

Active Member
Joined
Aug 14, 2002
Messages
290
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??
 

Some videos you may like

Excel Facts

How can you automate Excel?
Press Alt+F11 from Windows Excel to open the Visual Basic for Applications (VBA) editor.

BrianB

Well-known Member
Joined
Feb 17, 2003
Messages
8,127
Another column I think with a formula like :-
=IF(OR(ISBLANK(A1),ISTEXT(A1)),"Yes","No")
 

Watch MrExcel Video

Forum statistics

Threads
1,118,117
Messages
5,570,278
Members
412,316
Latest member
JabirS
Top