Solved: Value Matching Validation

[anthony20069]

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]

Try this

[anthony20069]

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 , thanks VERY much

[anthony20069]

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]

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]

excellent thanks very much