Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
hari
 
Posts: n/a
Default Advanced Filter for exact value

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
  #2   Report Post  
Dave Peterson
 
Posts: n/a
Default Advanced Filter for exact value

See the second response to your other post (in .excel).

hari wrote:

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


--

Dave Peterson
  #3   Report Post  
Paul Sheppard
 
Posts: n/a
Default Advanced Filter for exact value


hari Wrote:
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


Hi Hari

Try Data Filter Autofilter Custom Ends with C2 Or B1


--
Paul Sheppard


------------------------------------------------------------------------
Paul Sheppard's Profile: http://www.excelforum.com/member.php...o&userid=24783
View this thread: http://www.excelforum.com/showthread...hreadid=484056

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
advanced filter criteria "begins with" and "does not begin with" raph_baril Excel Worksheet Functions 3 June 28th 05 10:38 PM
Using advanced filter to search for criteria in a list Potatosalad2 Excel Discussion (Misc queries) 1 June 8th 05 03:08 AM
Can Excel advanced filter be used in "and NOT" mode Robert Excel Worksheet Functions 1 January 27th 05 03:57 PM
Advanced Filter: No Filter Evan Weiner - Richalnd WA Excel Discussion (Misc queries) 2 December 9th 04 05:36 PM
advanced filter won't allow me to filter on bracketed text (-456.2 LucianoG Excel Discussion (Misc queries) 1 December 6th 04 09:38 PM


All times are GMT +1. The time now is 12:11 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"