P
pierre
i have elements in column A and elements in column B
my goal is to be able apply a color for elements who show as duplicates
i.e :
column A column B
tree fork
tree fork
if "tree" and "fork" show twice , i want to make them appear as yellow color
So i have made a conditional format formula like this:
=SUMPRODUCT(--(($A$1:$A$100)&($C$1:$C$100)=A2&C2))>1
MY QUESTION : is there a way to develop this formula in the same context ??
i mean i want more details like this :
---($A$1:$A$100=a2) and --($C$1:$C$100=c2)
please help
my goal is to be able apply a color for elements who show as duplicates
i.e :
column A column B
tree fork
tree fork
if "tree" and "fork" show twice , i want to make them appear as yellow color
So i have made a conditional format formula like this:
=SUMPRODUCT(--(($A$1:$A$100)&($C$1:$C$100)=A2&C2))>1
MY QUESTION : is there a way to develop this formula in the same context ??
i mean i want more details like this :
---($A$1:$A$100=a2) and --($C$1:$C$100=c2)
please help