Hi All,

Please help on the issue below.

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,
Hari