Will this work, copied down
=IF(COUNTIF(G:G,H:H)0,G1,"")

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Mike" wrote in message
...
Please help. I download stock symbol EOD (End of Day) data into Excel
2000.
Columns are titled Symbol, Date, Close, Volume. I am trying to compare
the
closing price and volume columns for 2, 3, and 5 consecutive days.
However,
for example Nasdaq, on one day contains 3, 340 symbols, the next day 3,
352
symbols. I would like to compare columns and retain in another column
those
symbols that are common. Would appreciate any help possible. Thanks in
advance.