Advanced Filter for exact value

[hari]

I tried to do advanced filter for the below list, where "BF BGA" is the
header row:
BF BGA
BF304 C20
BF328 B15
BF348 B10
BF343 B11
BF294 C22
BF199 AD26
BF374 B4
BF1 E5
BF3 C2
BF4 E4
BF5 B1

Using the criteria:
BGA
C2
B1

The goal is to filter for the values C2 and B1 only. But it filters all
values containing C2 and B1 as below:
BF BGA
BF304 C20
BF328 B15
BF348 B10
BF343 B11
BF294 C22
BF3 C2
BF5 B1


How can I filter on entire contents.

Thanks,
Madan

 

[Dave Peterson]

Try this in your criteria range:

BGA
=C2
=B1


Debra Dalgleish has some tips (including this one) at:
http://contextures.com/xladvfilter01.html

 

[Dave Peterson]

I pasted from excel and lost my formulas!

Try this:

BGA
="=C2"
="=B1"

But Debra still shows it correctly at:
http://contextures.com/xladvfilter01.html

 

[hari]

Dave,

Thanks! I already figured this one out. Actually I wrote a formula to
get ="=text" since I had several entries in my criteria list. The
formula is:
=concatenate("=",cellname)
and I used this new list as my criteria.

Madan