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...
=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))
=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.
