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
1 Reply
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
