Forum Discussion
Solved
Vlookup
Hi All,
Can you help me with below please?
| company | Platform |
| abc co | 123 |
| abc co | 456 |
| xyz co | 123 |
| xyz co | 456 |
| yyy co | 456 |
i made up above data since i cannot share my actual data. i am looking to filter out company names with 456 platform only. for example, abc co has both 123 and 456 so i want a false value next to it. where as i want true value for yyy
=LET(A,A2:A10, e,UNIQUE(A), ok,COUNTIFS(A,e,$B$2:$B$10,456), company,COUNTIF(A,e), result,FILTER(e,ok=company), result)Is this what you want to do?
If you don't work with Office365 or 2021 you can try this formula:
=NOT(COUNTIFS($A$2:$A$14,A2,$B$2:$B$14,456)<COUNTIF($A$2:$A$14,A2))
3 Replies
=LET(A,A2:A10, e,UNIQUE(A), ok,COUNTIFS(A,e,$B$2:$B$10,456), company,COUNTIF(A,e), result,FILTER(e,ok=company), result)Is this what you want to do?
If you don't work with Office365 or 2021 you can try this formula:
=NOT(COUNTIFS($A$2:$A$14,A2,$B$2:$B$14,456)<COUNTIF($A$2:$A$14,A2))- Thank you so much. the second formula worked. but what if i want to look for two values.
company Platform
abc co 123
abc co 456
abc co 789
xyz co 123
xyz co 456
yyy co 456
uuu co 789
as in, what if i want both 456 and 789=NOT(SUM(COUNTIFS($A$2:$A$12,A2,$B$2:$B$12,{456,789}))<COUNTIF($A$2:$A$12,A2))Is this what you want to do? Enter the formula with ctrl+shift+enter if you don't work with Office365 or 2021.
