Question with use of advanced filter to select empty cells

R

RAJ

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
 
D

Dave Peterson

Try
="="

(Thanks, Debra!)
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
Click to expand...
 
D

Dave Peterson

Preformat the cell as text or start with an apostrophe: '=

Another one to try to remember!
 
D

Dave Peterson

Hey, I didn't need to make it text. I thought that xl would yell at me--but it
didn't!
 
Top