Hi, Sheet1 has names column. sheet2 has also ...

(Etwo Cargo) #1

Hi, Sheet1 has names column. sheet2 has also names column. Names is key column. What should be formula of in the sheet2 column to show names which are not in sheet1 column name? NOT(IN(…

(Steven Coile) #2

(sheet2[names] - sheet1[names]) will show the names that occur in sheet2 that do not also occur in sheet1

(Etwo Cargo) #3

+Steve Coile O my god. How it was simple! Thanks a lot. :slight_smile:

(Steven Coile) #4

:slight_smile: