Forum Discussion

Torbjorn_Hedberg's avatar
Torbjorn_Hedberg
Copper Contributor
Jul 08, 2022
Solved

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...
  • HansVogelaar's avatar
    Jul 08, 2022

    Torbjorn_Hedberg 

    If you have Microsoft 365 or Office 2021:

     

    =UNIQUE(FILTER(A2:A20,COUNTIFS(A2:A20,A2:A20,B2:B20,"")=0))

Resources