Forum Discussion
Torbjorn_Hedberg
Jul 08, 2022Copper Contributor
Find keys with no corresponding empty rows
Hi! I want find all keys where none of the corresponding values are empty. So in the example below I want "Name two" and "Name three" as a result. Shouldn't be hard but I just can't come up with...
- Jul 08, 2022
If you have Microsoft 365 or Office 2021:
=UNIQUE(FILTER(A2:A20,COUNTIFS(A2:A20,A2:A20,B2:B20,"")=0))
HansVogelaar
Jul 08, 2022MVP
If you have Microsoft 365 or Office 2021:
=UNIQUE(FILTER(A2:A20,COUNTIFS(A2:A20,A2:A20,B2:B20,"")=0))
- Torbjorn_HedbergJul 08, 2022Copper ContributorAmazing. Thanks so much!