Thank you so much you ahve no idea how much help this will be in the
future.....

"JE McGimpsey" wrote:

See

http://cpearson.com/excel/Duplicates.aspx

In article ,
Megan wrote:

I have 3 columns in a spread sheet
A, B & C
The numbers in column A I want to be alerted if they are repeated in column
C, if possable I would like some kind of alert or notice in column B next to
the repeated number. Please help.