Unique data
 

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.

Unique data
 

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.
FormatConditional Formatting choose drop down Formula Is
=COUNTIF(C:C,C1)1
Choose Format and select Font Red and Bold

--
Regards

Roger Govier


"Moist" wrote in message
...
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.

Unique data
 

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

Regards,
Stefi


€žRoger Govier€� ezt Ã*rta:

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.
FormatConditional Formatting choose drop down Formula Is
=COUNTIF(C:C,C1)1
Choose Format and select Font Red and Bold

--
Regards

Roger Govier


"Moist" wrote in message
...
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.