| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Data Validation on multiple columns
I have id tag numbers in two columns (columns F and G) and I need to check
that each id tag number is only used once. (eg. if an id number is used in column F I need to check that it is not used again in either column F or column G). Can I use DataValidation. Custom with some variation of the countif formula. Thanks |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Dependent list in data validation - more than 2 columns | Excel Worksheet Functions | |||
| Data validation: wider window on 14 columns | Excel Discussion (Misc queries) | |||
| Data Validation & multiple columns | Excel Discussion (Misc queries) | |||
| Data validation for Multiple columns | Excel Discussion (Misc queries) | |||
| data validation list from two columns | Excel Discussion (Misc queries) | |||
Threaded Mode
