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. |
Unique entry - Data Validation
On Mar 20, 11:13 am, "andrewmac" wrote:
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. Thanks folks but I found the solution with a search in this newsgroup - sorry if anyone has wasted any time! |
Unique entry - Data Validation
Maybe you can use the technique from Debra Dalgleish's site:
http://contextures.com/xlDataVal03.html andrewmac wrote: 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. -- Dave Peterson |
All times are GMT +1. The time now is 10:44 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com