Formula for duplicate entry

[Guest]

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.

 

[Max]

.. setup a formula to check for a duplicate entry.
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 price row.
when I key in the price at $3.00
the system will prompt me or give me an error.

On the face of it .. try this

Assume table in cols A & B,
data from row2 down
price in col B

Select col B
Click Data > Validation
Allow: Custom
Formula: =COUNTIF(B:B,B1)<2
Click OK


---