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
Hello,



Hello,
i have data in 2 columns, for
ex:
Column A: Bearing, Ball, 1/2 in, Cast Iron
Column B: Bearing, Ball, Cast Iron

by seeing this example we know that 1/2 in is missed in column B, so i need this missed value highlighted in Column C

Please help me to get this solved
can help this text and forward to my mail
Related:

1 response

TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 552
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
0
dear Trowad , inside of cell some of charterers are missing .
both cells are same but few arguments are missing
could any suggest to me
0
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 552
Apr 19, 2018 at 11:33 AM
Hi Surenda,

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
0