Chip Pearson has a bunch of techniques for working with duplicates at:
http://www.cpearson.com/excel/duplicat.htm

"LittleJoe <" wrote:

I have a 2 column worksheet like below but having hundreds of lines
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 several
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/

--

Dave Peterson