Extract missing word from text string
Closed
surendra
-
Updated on Apr 19, 2018 at 11:35 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - Apr 19, 2018 at 11:33 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - Apr 19, 2018 at 11:33 AM
Related:
- There are three elements that relate to the way that vpns operate. work out what letters are missing from this word to reveal one of the elements.
- Four elements trainer - Download - Adult games
- Free photoshop elements - Download - Image editing
- Little alchemy all elements - Guide
- Word apk for pc - Download - Word processors
- Could not complete this operation. there was not enough memory available - Guide
1 response
TrowaD
Posts
2921
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
December 27, 2022
555
Apr 19, 2018 at 11:14 AM
Apr 19, 2018 at 11:14 AM
Hi Surendra,
The following formula will place all missing data from column B in column C:
C1: =IF(ISERROR(VLOOKUP(A1,B:B,1,0)),A1,"")
Drag formula down for the rest of the results.
Best regards,
Trowa
The following formula will place all missing data from column B in column C:
C1: =IF(ISERROR(VLOOKUP(A1,B:B,1,0)),A1,"")
Drag formula down for the rest of the results.
Best regards,
Trowa
Apr 19, 2018 at 11:25 AM
both cells are same but few arguments are missing
could any suggest to me
Apr 19, 2018 at 11:33 AM
Putting multiple values in a single cell is not the way to work with Excel.
Try using the text delimiter option (found under the Data ribbon) and then transpose your data (a paste special option) to setup your data the "right" way.
Best regards,
Trowa