Quote Originally Posted by AliGW View Post
Glenn told you about that - get rid of the space characters in the 'empty' cells in B and C.

Or use this:

=LET(f,FILTER(B2:C37,NOT(ISNUMBER(MATCH(B2:B37,D2:D37,0)))),FILTER(f,INDEX(f,,1)<>" "))

I did miss it but this works also! You're a wizard too! Thank you very much. I honestly have no clue what I'm reading between both formulas that work but both results are exactly what I'm looking for. I'm looking for some solid beginner courses for excel. I need to learn the language.