Look at Chip Pearson's page on duplicates

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

--
Regards,
Tom Ogilvy


"question12" wrote:

Hi, I have an excel file that reads in data from a text file. After the data
is read in, I want to check a column of data (job #'s) to see if any repeat.
If it does repeat, I want to display a message to the user which rows repeat.

Can this be done in excel? Thank you for your help