View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Raj Raj is offline
external usenet poster
 
Posts: 130
Default 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