| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Data Validation Excel 2003
I have to update a workbook for a customer regarding PCs that my company
ships out. Two of the fields that we record are ASSET TAG and SERIAL NUMBER. These 2 pieces of data are already linked prior to shipment. For example SN 1234 is linked to asset ABCD. I'd like to do a validation on this data as I enter it to ensure there are no typos, or multiple assets assigned to 1 SN. Which Excel Formula should i use for this? ANy thoughts |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Passwords and Encryption for Excel 2003 for Validation Purposes. | Excel Discussion (Misc queries) | |||
| Tricky problem in Data validation - Excel 2003 | Excel Discussion (Misc queries) | |||
| Excel 2003 - Data Validation | Excel Discussion (Misc queries) | |||
| Conditional Data Validation possible in Excel 2003? | Excel Discussion (Misc queries) | |||
| Validation Confusion-Excel 2003 | Excel Discussion (Misc queries) | |||
Threaded Mode
