SOLVED
Home

Filter a list in place

%3CLINGO-SUB%20id%3D%22lingo-sub-88261%22%20slang%3D%22en-US%22%3EFilter%20a%20list%20in%20place%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-88261%22%20slang%3D%22en-US%22%3E%3CP%3EI%20want%20to%20filter%20the%20following%20list%20in%20place%20where%20any%20of%20the%204%20quartely%20columns%20contain%20the%20number%203.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EName%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%20Q1%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%20Q2%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%20Q3%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%20Q4%3C%2FP%3E%3CP%3EPeter%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%201%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%204%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%202%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%201%3C%2FP%3E%3CP%3ELynn%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%202%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%201%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%203%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%204%3C%2FP%3E%3CP%3EKevin%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%203%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%204%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%201%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%201%3C%2FP%3E%3CP%3EPaul%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%204%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%202%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%202%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%204%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThe%20answer%20I%20should%20receive%20is%20the%20row%20with%20Lynn%20and%20the%20row%20with%20Kevin.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAny%20help%20you%20can%20provide%20would%20be%20greatly%20appreciated.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-88261%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFilter%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-88295%22%20slang%3D%22en-US%22%3ERe%3A%20Filter%20a%20list%20in%20place%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-88295%22%20slang%3D%22en-US%22%3E%3CP%3EThanks%20Detlaf---that%20worked%20perfectly.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-88278%22%20slang%3D%22en-US%22%3ERe%3A%20Filter%20a%20list%20in%20place%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-88278%22%20slang%3D%22en-US%22%3E%3CP%3EHi%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EInsert%20a%20helper%20column%20...%3C%2FP%3E%3CPRE%3E%3DCOUNTIF(Table1%5B%40%5BQ1%5D%3A%5BQ4%5D%5D%2C3)%26gt%3B0%3C%2FPRE%3E%3CP%3E...%20and%20filter%20on%20TRUE.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Peter Rosen
New Contributor

I want to filter the following list in place where any of the 4 quartely columns contain the number 3.

 

Name     Q1     Q2     Q3     Q4

Peter       1        4        2        1

Lynn        2        1        3        4

Kevin       3        4        1        1

Paul         4        2        2        4

 

The answer I should receive is the row with Lynn and the row with Kevin.

 

Any help you can provide would be greatly appreciated.

2 Replies
Highlighted
Solution

Hi

 

Insert a helper column ...

=COUNTIF(Table1[@[Q1]:[Q4]],3)>0

... and filter on TRUE.

 

Highlighted

Thanks Detlaf---that worked perfectly.

Related Conversations