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...

Matching Formula ??
 

Don't use two tables. Put it all in one table and then use a Pivot Table.
This will give you what you're looking for and more. you'd be able to do
sums, counts, avgs, etc. and never write a single formula.

"carl" wrote:

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...