Try this Add-in (Compare)
http://www.cpearson.com/excel/download.htm

This Add-In utility allows you to compare the contents of two workbooks. This was written by Myrna Larson and Bill Manville.


--
Regards Ron de Bruin
http://www.rondebruin.nl


"kman" wrote in message
...

Hi,
I have 2 worksheets with intraday stock data containing the following
data:
price, and deal hour (in minutes).
I want to compare the two worksheets and put in third worksheet all the
deals that were made in the same minute.
for example:
first work sheet
time price
10:01 100
10:05 101
10:07 102
10:10 103

second work sheet
time price
10:02 100
10:03 101
10:05 102
10:06 103
10:07 103

so i want excel to put in the third worksheet all the deals made in the
same minute:

time price
10:05 101
10:07 102

thanks


--
kman
------------------------------------------------------------------------
kman's Profile: http://www.excelforum.com/member.php...fo&userid=3337
View this thread: http://www.excelforum.com/showthread...hreadid=487948