Hey all,
I'm working on a few dynamic KPI charts and could use a little help with figuring out data valuation for the End Date value.
In the attached workbook I am using data validation to pick a start date from a dynamic list (Dates) in E2:Exxx. Cell B2 has 2/8/2010 picked. I would like to have a drop down in B2 show the listing of all dates in E2:Exxx which occur after 2/8/2010, so the filtered list would be in the range E3:E49.
As always every suggestion is greatly appreciated.
Last edited by scaffdog845; 02-18-2010 at 03:24 PM.
Click here to read the Forum Rules
To give a virtual "pat on the back" click the SCALES Icon in the SILVER toolbar from that user's post.
Try adding a Named Range EndDates with Refers To: formula to:
=INDEX(Sheet1!$E:$E,MATCH(Sheet1!$B$1, Sheet1!$E:$E, 0) +1 ):INDEX(Sheet1!$E:$E,MATCH(99^99, Sheet1!$E:$E))
Last edited by JBeaucaire; 02-17-2010 at 03:35 PM.
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use theicon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
“None of us is as good as all of us” - Ray Kroc
“Actually, I *am* a rocket scientist.” - JB (little ones count!)
JBeaucaire,Originally Posted by JBeaucaire
This woprks great thanks. I looked at it a bit last night from home and came up with a differnt solution whic was no quite as efficient. I created another named range for end dates using the chosen start date + 7 as the first date then incremented each additional value by 7.
Your solution aalows me to do away with this "Helper" column.
Thanks
Click here to read the Forum Rules
To give a virtual "pat on the back" click the SCALES Icon in the SILVER toolbar from that user's post.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks