Compare two columns in excel and create the third

Asked

Viewed 29 times

2

I need to compare the Column A item with all items in column B, if this item is not present in column B, it is generated in column C. What formula do I need to use to do this?

Exemplo no excel

excel google-sheets

1 answer

1

I managed to solve alone, I used the following function

=FILTER(A2:A; NOT(COUNTIF(B2:B; A2:A)))

inserir a descrição da imagem aqui

Browser other questions tagged excel google-sheets

You are not signed in. Login or sign up in order to post.