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
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