PDA

View Full Version : Solved: Entering same info twice



Blackie50
07-05-2012, 07:43 AM
Hi

is it possible to be alerted somehow when entering the same information in to a particular column/cell in a spreadsheet?

e.g

enter 5462318P1 in to cell A1

and then enter it again in to cell A2345

message something like 'entry exists' (at cell reference preferably)


thanks for any help
Jon

Bob Phillips
07-05-2012, 07:53 AM
Select all target cells starting at A2 and add Data Validation, type Custom, formula of =COUNTIF($A$2:$A2,$A2)=1

Blackie50
07-06-2012, 01:42 AM
Thanks very much

Works like a charm

regards
Jon