Find keys with no corresponding empty rows

Question

Hi!&nbsp;&nbsp;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 a way!?&nbsp;&nbsp;&nbsp;KeyValueName one&nbsp;123Name one&nbsp;345Name one&nbsp;456Name one&nbsp;&nbsp;Name one&nbsp;345Name two345Name two435Name two576Name two678Name two898Name three&nbsp;345Name three&nbsp;345Name three&nbsp;456Name three&nbsp;324Name four&nbsp;&nbsp;Name four&nbsp;234Name four&nbsp;&nbsp;Name four&nbsp;&nbsp;Name four&nbsp;876&nbsp;&nbsp;&nbsp;&nbsp;Wanted result (no empty cells in row B)&nbsp;Name two&nbsp;&nbsp;Name three&nbsp;

hansvogelaar · Accepted Answer

Torbjorn_Hedberg&nbsp;
If you have Microsoft 365 or Office 2021:
&nbsp;
=UNIQUE(FILTER(A2:A20,COUNTIFS(A2:A20,A2:A20,B2:B20,"")=0))

Forum Discussion

Find keys with no corresponding empty rows

2 Replies

Resources

Key	Value
Name one	123
Name one	345
Name one	456
Name one
Name one	345
Name two	345
Name two	435
Name two	576
Name two	678
Name two	898
Name three	345
Name three	345
Name three	456
Name three	324
Name four
Name four	234
Name four
Name four
Name four	876


Wanted result (no empty cells in row B)
Name two
Name three