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 |
All times are GMT +1. The time now is 12:34 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com