View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
JMay JMay is offline
external usenet poster
 
Posts: 422
Default 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.