Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
validation for three input fields
Hi all,
I would like to do validation on three fileds' combination in order to make them unique, for example in following case the row1 and row2 input combination(A, B, C) is same so it is not allowed. A B C D 1 1 2 3 =A1&B1&C1 2 1 2 3 =A2&B2&C2 what I do is add formula in colum D to get the combination of A,B,and C and use a validation fomula like: =countif(&D&1:$D$2, D1)=1 to force the uniqueness, but it does not work as assumed. Clara -- thank you so much for your help |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Fields requiring input | Excel Programming | |||
create template with certain fields to input information only | Excel Worksheet Functions | |||
Input one criteria to search in 5 fields | Excel Discussion (Misc queries) | |||
Input box fields | Excel Programming | |||
using an input box to allow users type in the differnt fields name | Excel Programming |