Forum Discussion
Solved
Looking for help on what Function to use
I have two columns of names in excel. Column 1 has all names , column 2 has a majority of names. What function can I use to see which names in column 1 don’t appear in column 2? Thank you for any guid...
Let's say the names are in A2:A100 and D2:D50.
In B2 (or another cell in row 2), enter the formula
=ISERROR(MATCH(A2,$D$2:$D$50))
This will return TRUE if the value of A2 does not occur in B2:B50, FALSE otherwise.
Fill down to row 100.
You can also use this formula in a conditional formatting rule for A2:A100 of type 'Use a formula to determine which cells to format' to highlight the non-matching names.
Taking HansVogelaar sample, on modern Excel that could be
=FILTER(A2:A100,COUNTIF(D2:D50,A2:A100)=0)assuming you have no blank cells in ranges, otherwise it'll be bit more complex.
- Thank you. Love this site. So amazing
