Hi!
for comparing spreadsheets you can try this add-in:
http://www.office-excel.com/excel-ad...eadsheets.html
Hope it helps!

Best regards,
Eugene
"Darshan" wrote in message
...
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.