You can make a difference in the Apple Support Community!
When you sign up with your Apple Account, you can provide valuable feedback to other community members by upvoting helpful replies and User Tips.
When you sign up with your Apple Account, you can provide valuable feedback to other community members by upvoting helpful replies and User Tips.
How do i filter a common name in the entire table or multiple columns.
for instance :
in the above table i want to filter the table in a way that all the columns containing apple are show and all the rest are hidden ?
the filter function works well for one column but how to i apply it in multiple columns ??
iPad Pro, iPadOS 14
Md_mazahir wrote:
in the above table i want to filter the table in a way that all the columns containing apple are show and all the rest are hidden ?
I assume you mean show all the rows containing Apple, as you can't filter out columns. If so, you can do something like this:
When you flip the switch to turn on filters you get this:
The trick is to choose 'Match Any Filters.'
SG
Md_mazahir wrote:
in the above table i want to filter the table in a way that all the columns containing apple are show and all the rest are hidden ?
I assume you mean show all the rows containing Apple, as you can't filter out columns. If so, you can do something like this:
When you flip the switch to turn on filters you get this:
The trick is to choose 'Match Any Filters.'
SG
Md_mazahir wrote:
in my actual table i am having almost 30 columns and its not really practical to apply filter in 30 columns each time .
is there any kind of a formula that can be applied on the entire table (except the header column and header row ),
You can add a filter column (which you can hide after you have gotten it working) and filter on that added column.
The formula in F2 of the example, filled or copied down that column, is:
=COUNTIF(B2:E2,"Apple")>0
If your region uses , as a decimal separator use:
=COUNTIF(B2:E2;"Apple")>0
You will of course need to adjust the B2:E2 to match the actual columns you are using in your table.
This will return TRUE if any of the value in any of the cells is Apple. If you want it to also include, say, Apples then you could try adding the wildcard:
=COUNTIF(B2:E2,"Apple*")>0
Then set up the filter on the filter column like this;
SG
thanks for the reply ,
but in my actual table i am having almost 30 columns and its not really practical to apply filter in 30 columns each time .
is there any kind of a formula that can be applied on the entire table (except the header column and header row ), searching for apple and all the rows containing apple remain and rest all the rows are hidden .
Tia
Filter in multiple columns
