excel:how to select values from column A which its values don't exist in column B

The name of the pictureThe name of the pictureThe name of the pictureClash Royale CLAN TAG#URR8PPP



excel:how to select values from column A which its values don't exist in column B


+-------+--------+
| A | B |
+-------+--------+
| apple | mouse |
| pie | dog |
| car | phone |
| mouse | plane |
| cat | bag |
| dog | tree |
| phone | flower |
+-------+--------+



table is like this and how to select the values from column A which its values don't exist in column B,then get:


+-------+
| C |
+-------+
| apple |
| pie |
| car |
| cat |
+-------+



I could only use excel in my computer..




1 Answer
1



In C1, write =if(isna(match(A1,B:B,0)),A1,"")


C1


=if(isna(match(A1,B:B,0)),A1,"")








By clicking "Post Your Answer", you acknowledge that you have read our updated terms of service, privacy policy and cookie policy, and that your continued use of the website is subject to these policies.

Popular posts from this blog

Firebase Auth - with Email and Password - Check user already registered

Dynamically update html content plain JS

How to determine optimal route across keyboard