Quote:
Originally Posted by TheNorm
They would be if you included them in the string. To use your example:
E1 = A1 & B1 & C1 & D1 = oneDogCatFish
E2 = A2 & B2 & C2 & D2 = twoElephantGiraffeBird
E3 = A3 & B3 & C3 & D3 = oneDogElephantFish
You want every E to be unique. No?
|
Not exactly, I want every E to be unique for all the different catagories in column A, and for the formula to tell me if they are not unique.
Many thanks
Abs