Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 313
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Can't analyze web data willemeulen[_45_] Excel Worksheet Functions 0 June 12th 09 02:57 PM
How do I analyze data using time periods? Frankie Excel Discussion (Misc queries) 1 June 1st 08 05:38 PM
how to analyze data? linda Excel Discussion (Misc queries) 40 September 13th 07 10:30 AM
Analyze Data tokentrinkit Excel Worksheet Functions 3 August 18th 06 08:01 PM
MISSING: Analyze Timescale Data Bettergains Excel Programming 2 November 16th 04 10:51 PM


All times are GMT +1. The time now is 01:38 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"