Extract missing word from text string

Closed
-
Posts
2848
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
January 25, 2022
-
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

1 reply

Posts
2848
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
January 25, 2022
491
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
dear Trowad , inside of cell some of charterers are missing .
both cells are same but few arguments are missing
could any suggest to me
Posts
2848
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
January 25, 2022
491
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