PDA

View Full Version : Solved: Value Matching Validation



anthony20069
04-29-2009, 03:11 AM
Hi all,

Wondering you could assist please. Wat i would like some help with is if there is a way to match if the same value is being use...

Example:

C6:F12 is like my "table"

As you can see in C6 + C9 they both have the same value also C8 + E6 have the same values, what i would like is an error to appear if the same values are used twice (hope this makes sense)

I have tried IF statments but with no success.....

Any help much appriecated :)


Thanks in advance

Bob Phillips
04-29-2009, 03:31 AM
Try this

anthony20069
04-29-2009, 03:36 AM
WOW, that is amazing... Thanks very much xld

*****

Just to mix things up a bit, would you be able to do it with text instead of numbers??

***** it works with text also :D, thanks VERY much

anthony20069
04-29-2009, 07:06 AM
Ok sorry for the double post, but could you inform me on how to add more things to the list? every time i try to add a new row, I get this error "You cannot change part of an array"....

Thanks

Bob Phillips
04-29-2009, 08:27 AM
Select all of the c ells in column D that align to your (current) values in column B, then go to the bottomn right of that selection until the cursor changes to a black cross, mosue drag down howvere many more cells you need. Then hit F2, and change the 15 in the formula to your new last row, and array enter it (Ctrl-Shift-Enter). Finally, copy the formula in column c down as well, this is just a regular formula.

anthony20069
04-29-2009, 08:59 AM
:D excellent thanks very much