Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Trying to get data between dates ranges to analyze
I am creating a spreadsheet to analyze product performance based on quarterly
data. It looks something like this. Search for Data results between: Beginning Date: Jan 1995 <--- Drop down menu Ending Date: Dec 2000 Performance Data for all dates: Date Product 1 Product 2 Product..... Jan'80 6.9% 7.30% 2.0% .. .. Feb'05 1.66 1.75% -3.84% Out put Range: Date Product 1 Product 2 Product..... Jan'95 =IF(AND(A3=Parameters!$K$3,A3<Parameters!$K$6),LO OKUP(Parameters!$B$14,'Quarterly Returns Input'!$C$1:$AY$1,'Quarterly Returns Input'!$C$4:$AY$4),"") The above formula is not working. Is there another method I could se that would search for data based on the date? Thank you for the help |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can't analyze web data | Excel Worksheet Functions | |||
How do I analyze data using time periods? | Excel Discussion (Misc queries) | |||
how to analyze data? | Excel Discussion (Misc queries) | |||
Analyze Data | Excel Worksheet Functions | |||
MISSING: Analyze Timescale Data | Excel Programming |