A
A shink
I am working on a spreadsheet to analyze data during different periods of
time. I am having difficulting creating a formula (tried imbeded if, and,
then statements unsuccessfully). How can I easily have a formula search for
product results easily between a beginning and ending dates so that I can
analyze that information only between the selected dates? The spreadsheet is
setup something like this:
parameter tab:
Beginning Quarter: Drop down of dates (i.e. 4th Quarter 1985)
Ending Quarter: Drop down of Dates (i.e. 1st Quarter 1999)
Input data tab:
Quarters Product 1 Product 2 Product....
1Q 1980 6.90 7.30 15
2Q 1980 1.5 0.520 -.01
..
..
..
4Q2004
Out Put tab:
Date Product 1 Product 2 Product.....
4Q1985
..
..
..
1Q1999
Results
Std Deviation
T-Statistic
etc...
thank you for the help
time. I am having difficulting creating a formula (tried imbeded if, and,
then statements unsuccessfully). How can I easily have a formula search for
product results easily between a beginning and ending dates so that I can
analyze that information only between the selected dates? The spreadsheet is
setup something like this:
parameter tab:
Beginning Quarter: Drop down of dates (i.e. 4th Quarter 1985)
Ending Quarter: Drop down of Dates (i.e. 1st Quarter 1999)
Input data tab:
Quarters Product 1 Product 2 Product....
1Q 1980 6.90 7.30 15
2Q 1980 1.5 0.520 -.01
..
..
..
4Q2004
Out Put tab:
Date Product 1 Product 2 Product.....
4Q1985
..
..
..
1Q1999
Results
Std Deviation
T-Statistic
etc...
thank you for the help