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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Data Validation on multiple columns
Can I use DataValidation. Custom with
some variation of the countif formula. Yes. Assume the range of interest is F1:G10 Select the range F1:G10 starting from cell F1. Cell F1 will be the active cell. Use a formula like this: =COUNTIF($F$1:$G$10,F1)<2 -- Biff Microsoft Excel MVP "NDBC" wrote in message ... 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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Data Validation on multiple columns
Thanks Biff. I didn't realise it needed the range to be in $ for it to work.
Is it possible to select the entire columns. I know when it is only one column you can use F:F but is there a similar code to do all of column F and G "T. Valko" wrote: Can I use DataValidation. Custom with some variation of the countif formula. Yes. Assume the range of interest is F1:G10 Select the range F1:G10 starting from cell F1. Cell F1 will be the active cell. Use a formula like this: =COUNTIF($F$1:$G$10,F1)<2 -- Biff Microsoft Excel MVP "NDBC" wrote in message ... 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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Data Validation on multiple columns
Try this:
=COUNTIF($F:$G,F1)<2 I don't know how efficient that'll be! -- Biff Microsoft Excel MVP "NDBC" wrote in message ... Thanks Biff. I didn't realise it needed the range to be in $ for it to work. Is it possible to select the entire columns. I know when it is only one column you can use F:F but is there a similar code to do all of column F and G "T. Valko" wrote: Can I use DataValidation. Custom with some variation of the countif formula. Yes. Assume the range of interest is F1:G10 Select the range F1:G10 starting from cell F1. Cell F1 will be the active cell. Use a formula like this: =COUNTIF($F$1:$G$10,F1)<2 -- Biff Microsoft Excel MVP "NDBC" wrote in message ... 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 |
Reply |
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) |