Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Stopping duplication within Data validation
I hope someone can help me with these problems!
I am using Data Validation for selected vehicles on runs, but I need to stop people assigning a duplicate registration for seperate runs. The list for the data validation is in cells D91 to D120 and the entries are made in cells H3 to H47 I have tried the following: (Cell H2) =ISERROR(MATCH(H2,H3:H47,0)) (Cells H3 to H47) =ISERROR(MATCH(H3,INDIRECT("$D$91:$D$120"ROW()-1),0)) But validation throws a wobbly and doesn't like the entry (which is exactly as I copied from help!) Where am I going wrong?? ALSO - on the same sheet I need to stop people using the vehicle Registrations from the validation in cells H48 to H60 - can I use the same validation list or do I have to set it up again PLEASE HELP ;-( Simon |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Stopping duplication within Data validation
In answer to your first part, it sounds like you want to hide previously used
entries. See Debra's aritcle: http://www.contextures.com/xlDataVal03.html Expanding on her idea, since your new list of values to use is created via formula, it would be a relatively simpel matter to have the formula not show values that are lsited in H48:H60. -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "SNA400" wrote: I hope someone can help me with these problems! I am using Data Validation for selected vehicles on runs, but I need to stop people assigning a duplicate registration for seperate runs. The list for the data validation is in cells D91 to D120 and the entries are made in cells H3 to H47 I have tried the following: (Cell H2) =ISERROR(MATCH(H2,H3:H47,0)) (Cells H3 to H47) =ISERROR(MATCH(H3,INDIRECT("$D$91:$D$120"ROW()-1),0)) But validation throws a wobbly and doesn't like the entry (which is exactly as I copied from help!) Where am I going wrong?? ALSO - on the same sheet I need to stop people using the vehicle Registrations from the validation in cells H48 to H60 - can I use the same validation list or do I have to set it up again PLEASE HELP ;-( Simon |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Data comparison for duplication | Excel Worksheet Functions | |||
Remove Duplication from Validation List? | Excel Discussion (Misc queries) | |||
Remove duplication from validation list? | Excel Worksheet Functions | |||
Stopping free text entry in validation cell | Excel Discussion (Misc queries) | |||
data duplication check ? | Excel Discussion (Misc queries) |