Advance filter

**zafar2002** · 11-15-2018, 08:47 PM

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

**jeffreybrown** · 11-15-2018, 09:01 PM

Originally Posted by zafar2002

Is there any formula which I can use to make my data formatted in a way that it appears in Advance filter option

That's quite the opened ended question. It's possible, and again, based on your data, maybe not.

See if this helps.

If not, then how about posting some sample data showing what you are trying to achieve.

Attach a sample workbook (not a picture or pasted copy). Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.