View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Carl Carl is offline
external usenet poster
 
Posts: 361
Default Matching Formula ??

I have these 2 tables:

Date UnderLyer 005S0F1 009F00OL
11-Oct QQQQ 2.92% 1.68%
11-Oct SPY 0.00% 0.00%
11-Oct AAPL 2.63% 0.00%
11-Oct RIMM 0.00% 0.00%
11-Oct IWM 1.15% 0.00%
11-Oct GM 0.60% 0.93%


Date Underlyer 005S0F1 009F00OL
10-Oct QQQQ 0.00% 0.83%
10-Oct SPY 0.00% 0.00%
10-Oct IWM 0.00% 0.00%
10-Oct RIMM 0.00% 0.00%
10-Oct AAPL 0.65% 0.00%
10-Oct DIA 0.00% 0.00%

I am trying to create this table:

005S0F1 005S0F1 009F00OL 009F00OL
10-Oct 11-Oct 10-Oct 11-Oct
QQQQ 0.00% 2.92% 0.83% 1.68%
SPY 0.00% 0.00% 0.00% 0.00%


Thank you in advance...