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