How can I to filter multi column
Ex: I want to filter "4" and dislay all row 1 and row 2 instead of dislay result from 1 colum. Please help me, thanks !
a 1 2 3 4 5
b 2 3 4 5 6
c 5 6 7 8 9
How can I to filter multi column
Ex: I want to filter "4" and dislay all row 1 and row 2 instead of dislay result from 1 colum. Please help me, thanks !
a 1 2 3 4 5
b 2 3 4 5 6
c 5 6 7 8 9
You must use a helper column
Assuming your data in A2:F4 and Row 1 has labels
You can use a helper column G2:G4 with the following array formula enter with CTRL+SHIFT+ENTER
=AND(A2:F2=4)
Select A1:G4 goto Data->Filter->Apply filters
Starting in column G, row 2 (as Jose pointed out about having the header row on row one), type this formula: =COUNTIF(B2:F2,"4")
If that "4" is going to change, designate a cell where you can change that number. Example: Cell H1 would have "4" in there. Then, change the formula from "4" to $H$1.
Example: =COUNTIF(B2:F2,$H$1) - Remember, the dollars signs lock the cell location to H1 when you copy the formula to another cell.
Every time you change the number in cell H1, the COUNTIF formula will now reflect the new number. You can then filter on column G.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks