Question with use of advanced filter to select empty cells
Hi,
Would appreciate if someone can help me with this:-
I got a range:-
first second
one a
two
three c
With the top line being column headings(first,second)...and I want to use
Advanced filter to copy the range where the second has no values....
I try this for the criteria range:-
second
=""
But that does not work...
Thanks
|