Thread: Stock Symbol Column comparison
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Harlan Grove[_2_] Harlan Grove[_2_] is offline
external usenet poster
  
Posts: 1,231
Default Stock Symbol Column comparison
"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,"")


Reply With QuoteReply With Quote