Problem of filter data<<help>>

[Closed]
Report
-
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
-
Hello,




i want to filter data in excel 07 wihich is filtered before.

2 replies


Hi there,

Please explain you issue with more information,whereas for filtering data on excel you can have the instructions and tutorials on link below:

https://support.microsoft.com/en-us/office/filter-data-in-a-range-or-table-01832226-31b5-4568-8806-38c37dcc180e?ocmsassetid=hp010073941&correlationid=52831e6d-a959-4b05-87e1-84f52f21ebcc&ui=en-us&rs=en-us&ad=us

Thanks
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
768
you can have a max of two filters on a column. If you need to apply more than two columns then you have to make use of temp columns that would hold results of two filters or you need a macro or a custom defined function