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

Question with use of advanced filter to select empty cells
 

Try
="="

(Thanks, Debra!)

RAJ wrote:

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

--

Dave Peterson

Question with use of advanced filter to select empty cells
 

or just =
(simply an equal sign)

"Dave Peterson" wrote:

Try
="="

(Thanks, Debra!)

RAJ wrote:

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

--

Dave Peterson

Question with use of advanced filter to select empty cells
 

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

Another one to try to remember!

Bob Umlas, Excel MVP wrote:

or just =
(simply an equal sign)

"Dave Peterson" wrote:

Try
="="

(Thanks, Debra!)

RAJ wrote:

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

--

Dave Peterson


--

Dave Peterson

Question with use of advanced filter to select empty cells
 

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

Bob Umlas, Excel MVP wrote:

or just =
(simply an equal sign)

"Dave Peterson" wrote:

Try
="="

(Thanks, Debra!)

RAJ wrote:

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

--

Dave Peterson


--

Dave Peterson

Question with use of advanced filter to select empty cells
 

Thanks a lot...it worked

"Dave Peterson" wrote:

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

Bob Umlas, Excel MVP wrote:

or just =
(simply an equal sign)

"Dave Peterson" wrote:

Try
="="

(Thanks, Debra!)

RAJ wrote:

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

--

Dave Peterson


--

Dave Peterson