Hello,

I have two worksheets which have similar values but are repeating. How do i
compare the two and get the items which are not reconciled. Eg

Sheet 1 Sheet 2
Column A Column A
50 50
100 25
25 50
50 100
100 300
25
25
100
200

I need to compare these two sheets and identify the reconciling items. I am
unable to use the vlookup function because of items being repeated.