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:
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VBAscript for data matching excels 0
Excel How to create a Accounts Receivable to calculate days in which payments against invoice are received 0
Data Validation to exclude blank cells 6
matching a column of numbers to another in another spreadsheet 1
sum unique in pivot table 1
finding unique values 2
Unique entry - Data Validation 2
Outlook Looking for macro to save multiple emails as .msg to folder and extracting the invoice ref. from the email body as the filename 4

Back
Top