If/then over entire row

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

5 joe cat excellen
5 joe cat excellen

I want E1 to state "unique" ONLY if A1=A2, B1=B2, C1=C2, and D1=D2. I can do this, but it is a cumbersome series of steps - any idea on how to do it in one formula?
 
The easy way requires another column to be created that is
concatenation of a1, b1, c1, d1

Use =A1 & B1 & C1 & D1 or use
=concatenate(A1,B,1,C1,D1) and then copy the formual dow for the entir
list.
Then in another column use the formula (assume it is in column f, th
concatenation in column e)
=if(countif(e1:e32767, e1)= 2, "Unique", "") and copy down for th
whole list
 
You can build the concatenate into the count in one step

In E1,
=IF($A$1:$A$100&$B$1:$B$100&$C$1:$C$100&$D$1:$D$100=A2&B2&C2&D2,"","Unique")

and copy down.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
Back
Top