"Mike" wrote:

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.

New post: I was a bit premature. Yes, the formula that I tried that Harlan
provided worked. However, now the resulting column has a blank cell at
Nasdaq company number 219 (took that long to find a difference). I'm using
old (7-2 and 7-3) data, but not important. Now, my question is how can I
transfer the price and volume info in columns C, D and G, H to Column K with
formula of Harlan in Column J. Columns contain A-Symbol B-Date 20070702
C-Close D-Volume E-Symbol F-Date 20070703 G-Close H-Volume I-blank J-Formula
Appreciate inputs.
Mike in Panama