Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
do not allow same data twice
I assume this is done through validation I just dont know how?
I have column B rows 1 to 500. I enter customer order numbers in on a daily basis, I want it to error out if I attempt to enter the same order more than once. For instance if I am on row 400 and I try typeing in order 123456 and it exists on row 286 it warns me or alerts me that it was already used? Any Ideas Would Be Great... Thanks... Sean |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
do not allow same data twice
Hi Sean
Use this http://www.cpearson.com/excel/NoDupEntry.htm -- Regards Ron de Bruin http://www.rondebruin.nl "Sean" wrote in message ... I assume this is done through validation I just dont know how? I have column B rows 1 to 500. I enter customer order numbers in on a daily basis, I want it to error out if I attempt to enter the same order more than once. For instance if I am on row 400 and I try typeing in order 123456 and it exists on row 286 it warns me or alerts me that it was already used? Any Ideas Would Be Great... Thanks... Sean |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Data Labels- POssible to show data value and data label together? | Charts and Charting in Excel | |||
Increase Your Business By Data Conversion, Data Format and Data EntryServices in India | Excel Worksheet Functions | |||
Save 20% On Data Conversion and Data Formats Services by Data EntryIndia | Excel Discussion (Misc queries) | |||
Data Entry Online, Data Format, Data Conversion and Data EntryServices through Data Entry Outsourcing | Excel Discussion (Misc queries) | |||
MULTIPLE DATA - How to insert new data into existing data.... | Excel Discussion (Misc queries) |