Forum Discussion
Selecting double values
I'm trying to colour all double values with the same adress. But the streetname is in column G and the number is in colum h. Can somebody help me out? Thanks
Hi Alien
Create the rule using the formula like
=SUMPRODUCT(($G$1:$G$100&$H$1:$H$100=$G1&$H1)*(LEN($G$1:$G$100&$H$1:$H$100)>0))>1
where 100 is more than your list size (otherwise take another number)
and apply it to your entire range
Result is like this