Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Unique entry - Data Validation
Hi,
I have a spreadsheet, each row of which represents an invoice from a third party. In column A we enter the invoice number and in the subsequent columns various information about the invoice. I want to set a data validation so that the person entering the invoice number is prevented from entering a number which has been used before. Can anyone tell me the correct formula? Many thanks, Andrew. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
DataValidationList - Unique Entries | New Users to Excel | |||
Unique numbers from data validation list | Excel Worksheet Functions | |||
Data Validation dependant and unique | Excel Worksheet Functions | |||
Data Validation / Cell Entry | Excel Discussion (Misc queries) | |||
Combining conditions for data entry validation | Excel Worksheet Functions |