View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Calculate Date range
 
Posts: n/a
Default Formula for duplicate entry

Hi all,

Me again.

I am facing some difficulties to setup a formula to check for a duplicate
entry.

For example.

Product name Price (in $)
A 3.00
B 1.20
C 5.00
D 3.00
( I plan to put in a formula if the price is the same price compare with the
rest of the pirce row. when I key in the price at $3.00 the system will
prompt me or give me an error.
E

Please let me know whether the formula is possible to create.