Advanced filtering in Excel Online?

[Jon Chambers]

Hello, I'm trying to find a workaround to the Excel Online filtering problem, whereby when one person filters a worksheet the filter applies to everyone else's view.

I thought maybe I could use Advanced Filtering to replicate some of the most common filters, but can't find a way of creating Advanced Filters in Excel Online.

Is this possible, and/or can anyone suggest a way of filtering data in Excel Online that doesn't affect the views of other people simulataneously editing the worksheet?

Thank you

[#2]

;@Jon Chambers I'm looking for the same answer, I think it's only available in offline apps

[#3]

@sweetsinner 

There were two different questions.

Is Advance Filter available for Excel Online? - no

Is it a way of filtering data in Excel Online that doesn't affect the views of other people simultaneously editing the worksheet? - Yes, that's Sheet Views in Excel