AdvancedFilter Macro

[Sahak]

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]

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

 

[Sahak]

PERFECT.
Thank you very much

 

[pgc01]

You're welcome.