Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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... |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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... |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Matching Formula ?? | Excel Worksheet Functions | |||
matching formula | Excel Worksheet Functions | |||
Help with matching formula | Excel Worksheet Functions | |||
matching formula | Excel Worksheet Functions | |||
Matching formula - i need help | Excel Discussion (Misc queries) |