Comparing values in two columns
In column C (New helper Column) enter =a1&b1 and Copy Down.
In Column D enter =IF(SUM(1/COUNTIF($C$1:$C$23,$C$1:$C1))=1,"***","")
and Copy Down.
HTH
"nicoll" wrote in message
...
My post didn't format the same as it appeared on my screen.
Column A contains the names, column B contains the numbers.
Thanks for your help.
|