AdvancedFilter Macro

Sahak

Well-known Member
Joined
Nov 10, 2006
Messages
850
Hi All,

I have a macro which makes AdvancedFilter in meals database. It makes filtering for all meals perfectly except, if CriteriaRange includes “SALAD”, with "SALAD" it filters "SALAD BAR" too. I need exact match, in this case "SALAD" only.
Thank you in advance
 

pgc01

MrExcel MVP
Joined
Apr 25, 2006
Messages
19,755
Hi

"salad" in the criteria range means you want the text to start with "salad"
You have to specify in the criteria range cell the value as exactly equal to salad.

2 ways

1 - With the cell formatted as General, use in the cell

="=SALAD"

2 - with the cell formatted as text, write

=SALAD
 

Forum statistics

Threads
1,085,307
Messages
5,382,838
Members
401,807
Latest member
xlWatcher

Some videos you may like

This Week's Hot Topics

Top