Unique data

M

Moist

I need to make a column in a spreadsheet so it will only accept unique date.

The basic requirement is......... I'm paying invoices and if I receive the
same invoice twice, (unless I do a search) it will allow me to enter the same
number in the column again, so I could end up paying the same invoice over
and over again.


Thank you in advance for any help given.
 
R

Roger Govier

Hi

There are many ways of achieving this. Perhaps the simplest would be
Conditional formatting
Supposing your invoice number are in column C, Highlight the range of
column C where you will be inputting invoice numbers.
Format>Conditional Formatting> choose drop down Formula Is>
=COUNTIF(C:C,C1)>1
Choose Format and select Font Red and Bold
 
S

Stefi

Or you can use
=COUNTIF(B:B,B1)<=1
as condition formula in Data/Validation/Custom.

Regards,
Stefi


„Roger Govier†ezt írta:
 
Top