Previous Topic Next Topic

How to find missing text or values comparing 2 cells

Closed
g1 - 9 Apr 2015 à 03:53
TrowaD Posts 2921 Registration date Sunday 12 September 2010 Status Contributor Last seen 27 December 2022 - 16 Apr 2015 à 11:11
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
Related:

2 responses

Réponse 1 / 2
TrowaD Posts 2921 Registration date Sunday 12 September 2010 Status Contributor Last seen 27 December 2022 555
9 Apr 2015 à 10:52
Hi g1,

The code below will loop through column A, comparing each value to column B. When a value is not found then that value will be pasted to column C.

Here is the code: 
Sub RunMe()
Dim lRow As Integer
Dim sValue As Range

lRow = Range("A" & Rows.Count).End(xlUp).Row

For Each cell In Range("A1:A" & lRow)
    Set sValue = Columns("B:B").Find(cell)
    If sValue Is Nothing Then
        Range("C" & Rows.Count).End(xlUp).Offset(1, 0).Value = cell.Value
    End If
Next cell
End Sub

Best regards,
Trowa
g1
10 Apr 2015 à 01:09
it is not met my requirement, i need Cell A1 to be compared with Cell B1 and missed value should get in the Cell C1, continuing A2 with B2 and result in C2 and so on.........

Please help me to get this.

Thanx
Réponse 2 / 2
TrowaD Posts 2921 Registration date Sunday 12 September 2010 Status Contributor Last seen 27 December 2022 555
13 Apr 2015 à 11:53
Hi g1,

Ok, that looks a lot simpler.

Use this formula in C1 and drag it down:
=IF(A1=B1,"",A1)

Does this meet your requirements?

Best regards,
Trowa
g1
14 Apr 2015 à 01:16
its not working..........can anybody help to get this.........
TrowaD Posts 2921 Registration date Sunday 12 September 2010 Status Contributor Last seen 27 December 2022 555
14 Apr 2015 à 11:02
Hi g1,

To me the formula is doing as requested:
A1: Bearing
B1: Bearing
No missed value so C1 is empty

A2: Ball
B2: Ball
No missed value so C1 is empty

A3: 1/2 in
B3: empty
The is a missed value so C1: 1/2 in

All this is achieved by the formula:
=IF(A1=B1,"",A1)

So there must be something you are not telling us.

Could you post some sample data how it is now and how you want it to look like?
Or consider the option to post (a part of) your workbook by using a file sharing site like www.speedyshare.com or ge.tt and post back the download link. Careful with sensitive information.

Best regards,
Trowa
g1 > TrowaD Posts 2921 Registration date Sunday 12 September 2010 Status Contributor Last seen 27 December 2022
15 Apr 2015 à 01:03
thnx, but my need is for ex: in cell A1: "Bearing, 1/2 in, stainless steel" and in Cell B1 "Bearing, 1/2 in" we can see that "stainless steel" is missed in cell B1, i need this missed value in C1
TrowaD Posts 2921 Registration date Sunday 12 September 2010 Status Contributor Last seen 27 December 2022 555
16 Apr 2015 à 11:11
Hi g1,

Let me give you some general Excel advise.

Don't put multiple values in the same cell. This will make processing your data a lot more easy.

If this data is provided to you this way, then use the Text to Columns option found under the Data ribbon.

Good luck,
Trowa

Similar discussions

Match value in 2 separate columns and return a value from a 3rd
JD_Silver -
TrowaD -

1 response
Fill adjacent cell with number from text answer
MitchP -
vcoolio -

20 responses