PDA

View Full Version : Selction based on drop down



applebee
2011-06-01, 06:33 PM
Hi

see this below

Q1 April May June
Q2 july august september
Q3 oct nov dec
Q4 jan feb mar


and the drop down says

select year and month : 2010.june

then i need to display april may and june
if april then my formula of excel needs to display only april
more detail is
if 2010.april now based onthis i need to select april month data from the Quarter1
if 2010.May is selected then i need to select april and may months data from Quarter 1
if 2010.june is selected then i need to select april , may and june i.e all the months data in the Quarter1

my question is how to write a formula based on this selection
the retrieving from data base i will take care

thanks for ur help

Ken Puls
2011-06-01, 07:33 PM
Hi Applebee, and welcome to the forum.

How about this?

applebee
2011-06-01, 07:38 PM
thanks Ken
that solves my issue

Ken Puls
2011-06-01, 07:43 PM
Great, glad to be of help. :)

NBVC
2011-06-01, 08:04 PM
Applebee,

Please avoid crossposting without links. Here's Why: Crossposting
(http://www.excelguru.ca/node/7)