2 column sort

L

LittleJoe

I have a 2 column worksheet like below but having hundreds of line
instead of these few.

Day 1
100.56
234.43-
405.43
6,506.00
1,304.00

Day 2
100.56
234.43-
405.43
6,506.00
1,304.00



What I need to do in Excel 2003:
Find any discrepencies between the columns.

1. Identify any items in column one which are not in column two.
2. Identify any items in column two which are not in column one.

Column 2 may arrive with several more items than it should, or severa
less.

I need a way to see what is extra or what is missing in column 2.

It is a real puzzler to me. Any code to help
 
M

MSP77079

I pasted your two examples into cells C4:C9 and E4:E9.

You will need to change the fixed cell ranges to variable cell ranges.
Post again if you need help doing that.

Sub test()

For i = 5 To 9
thisValue = Cells(i, "C").Text
Range("E4:E9").Select
Selection.AutoFilter Field:=1, Criteria1:=thisValue
Selection.SpecialCells(xlCellTypeVisible).Select
Set myRange = Selection
NumFound = myRange.Cells.Count - 1
MsgBox "I found " & NumFound & " entries for "
thisValue
Next i

End Su
 
Top