Disallow Repeat Entry

[Guest]

Hi

In a given column, how can I prohibit the user from re-entering value already entered in above row

Regard

Sachin

 

[Andy Brown]

In a given column, how can I prohibit the user from re-entering value
already entered in above rows

If you're looking for bullet-proof, you'd have to use code. If not, try Data
Validation ; see

http://www.contextures.com/xlDataVal07.html#Unique

Rgds,
Andy

 

[Andy B]

Hi

Select the column. Go to Data / Validation. Change the Allow option to
Custom and in the Formula box type:
=COUNTIF(F:F,F1)<2
This does not rule out the possibility of a user pasting/dragging a
duplicate number into the range

 

[Guest]

Thanx, that takes car

Sachin