This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
Accept
Reject
Preferences
Log in to ask a question
Log in to ask a question

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

Posted on 01-07-2019 04:00 PM
Etwo_Cargo
New Member
Reply posted on --/--/---- --:-- AM

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(โ€ฆ

0 3 319
0 Likes
3 REPLIES 3

Posted on --/--/---- --:-- AM
Steven_Coile
New Member
Reply posted on --/--/---- --:-- AM

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

0 Likes

Posted on --/--/---- --:-- AM
Etwo_Cargo
New Member
Reply posted on --/--/---- --:-- AM

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

0 Likes

Posted on --/--/---- --:-- AM
Steven_Coile
New Member
Reply posted on --/--/---- --:-- AM

0 Likes
Top Labels in this Space