Power Query Filter / Advance Filter (Contain) Not Giving Complete Results

[jamiemarie]

Good Morning, Back again with another question that probably has a simple solution.

In the Power Query Editor I am trying to filter my list of parts to only show Trays. If i Filter normally, I do get rows that contain the word "Tray", however it is not all of the rows. I'm getting 53 out of the 56 results I should be getting.



I found an article that said to use Advanced Filter's when in Power Query. So I did that, but got no results?

Can someone please explain what I need to do to get all rows that contain Tray?

PERSONAL (version 2).XLSB
	F
3
Sheet5

Thank you to anyone who takes the time to look at this for me.

 

[sandy666]

I don't know article you read
but what kind of filter you use?
text filter - contain - TRAY ?
remember that Power Query is case sensitive

 

[jamiemarie]

I don't know article you read
but what kind of filter you use?
text filter - contain - TRAY ?
remember that Power Query is case sensitive

See...I told you it would be stupid easy. It never once crossed my mind that I needed to use All Caps. Thank you so much Sandy.

This article, by the way.

 

[sandy666]

You are welcome
Thanks for the feedback