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(…
Etwo_Cargo (Etwo Cargo) #1
Steven_Coile (Steven Coile) #2
(sheet2[names] - sheet1[names]) will show the names that occur in sheet2 that do not also occur in sheet1
Etwo_Cargo (Etwo Cargo) #3
+Steve Coile O my god. How it was simple! Thanks a lot.
Steven_Coile (Steven Coile) #4