Actually, my formula was wrong anyway
=IF(COUNTIF(H:H,G1)0,G1,"")

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Harlan Grove" wrote in message
...
"Don Guillett" wrote...
Will this work, copied down
=IF(COUNTIF(G:G,H:H)0,G1,"")
...

It'd recalc very slowly. This alternative would recalc more quickly.

=IF(COUNT(MATCH(G1,H:H,0)),G1,"")