Thread
: [Solved]
Selecting blank cells in criteria
View Single Post
08-23-2011, 02:18 PM
OTPM
Windows 7 32bit
Office 2010 32bit
Expert
Join Date: Apr 2011
Location: West Midlands
Posts: 981
Hi
I have done some testing and it seems that you cannot do an advanced filter on Null cells. However if you put say a "." in each blank cell then you can use that as your criteria for filtering to another location.
Hope that helps.
Tony(OTPM)
OTPM
View Public Profile
Find all posts by OTPM