I am trying to use Advance filter and when I set a criteria, it doesnt bring results, even though the criteria item does exist. I have heard that if you are trying from a Raw data, it can cause problem. Is there any formula which I can use to make my data formatted in a way that it appears in Advance filter option?
Thanks for your help.

Zaf