[absthechatter]

Just when I thought I'd got my head around this formula business!!!!

Is it possible to write a formula (or better still, what is the formula) to check that any entries in column A that are identical, all have the same entries in columns B,C and D (although these entries are different from column A)?
i.e
A1 = one, B1 should = Dog, C1 should = Cat, D1 should = Fish.

A2 = two, B2 shoul = Elephant, C2 should = Giraffe, D2 should =Bird.

Now if A3 = one, instead of B3, C3 and D3 being Dog, Cat and Fish, it is Dog, Elephant and Fish, I want the formula to show me that the two are not equal.

There will be quite a few entries, so will probably need an array as well!!

Many thanks for all your help (and patience!)

Abs