Unique data

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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
 
Or you can use
=COUNTIF(B:B,B1)<=1
as condition formula in Data/Validation/Custom.

Regards,
Stefi


„Roger Govier†ezt írta:
 
Back
Top