Chip Pearson's page on working with duplicates and uniques should give you
some ideas:

http://www.cpearson.com/excel/duplicat.htm

--
Regards,
Tom Ogilvy

"John Fevens" wrote in message
om...
I have another question for you folks. So far so good, all of the
advice I have received has been very helpful.


We had a large workbook filled with data that looks something like
this:

Form# Date Comment Seq
11-1021212 2000/01/01 Comment 1
11-1021212 2000/01/01 Comment 2
11-1021212 2000/01/01 Comment 3
11-1021212 2000/01/01 Comment 4
11-1021212 2000/01/01 Comment 5
11-1021214 2000/01/01 Comment 1
11-1021214 2000/01/01 Comment 2
11-1021214 2000/01/01 Comment 3
11-1021214 2000/01/01 Comment 4
11-1021214 2000/01/01 Comment 5


What we have done with this is categorize it based on the comments,
selecting all of the rows associated to a from number and pasting them
in onto a different work sheet.


This is where the trouble starts.....

TO make this a bit easier, we took a large database and split it in 2
pieces (there were about 10,000 rows) When this was split, someone
forgot to sort the records by form#, now duplication exists in the 2
workbooks.


Is there any code that could identify for us IF a duplicate exists...
i.e. it is in both workbooks.....what sheet and cell location it is??



thanks in advance for your assistance.