Thread: IF formulas
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
JE McGimpsey JE McGimpsey is offline
external usenet poster
 
Posts: 4,624
Default IF formulas

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.