View Single Post
Old 23-01-2007, 18:01   #8
absthechatter
Inactive
 
Join Date: Dec 2004
Posts: 310
absthechatter is just really niceabsthechatter is just really niceabsthechatter is just really niceabsthechatter is just really niceabsthechatter is just really niceabsthechatter is just really nice
Re: Yet another Excel formula question for the experts!!

Quote:
Originally Posted by TheNorm View Post
Uhmmmm....

Do you mean:

For every value of A, the combined values in B, C and D should be unique; let me know if this is not the case.

What if:

A1 = one, B1 = Dog, C1 = Cat, D1 = Fish.

A3 = one, B3 = Dog, C3 = Elephant, D3 = Fish

A4 = one, B4 = Fish, C4 = Elephant, D4 = Dog << Would this be allowed?
I think that's it, for every value of A, the combined values of B,C and D should be unique! My bad explaining

So therefore the example would not be allowed.

Abs
absthechatter is offline   Reply With Quote