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

--
Message posted from http://www.ExcelForum.com