Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
macro | Excel Discussion (Misc queries) | |||
How can I average data from a repeating list into a unique list? | Excel Worksheet Functions | |||
ranking query | Excel Discussion (Misc queries) | |||
From several workbooks onto one excel worksheet | Excel Discussion (Misc queries) | |||
Help PLEASE! Not sure what answer is: Match? Index? Other? | Excel Worksheet Functions |