Excel 2007 : Quarters and months

**APPLEBEE** · 06-01-2011, 10:01 AM

Hi
Gurus

How do i get to choose the months in a quarter based on the selection.

I have created a dropdown where i can choose the year and month ex.
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 Quarter 1

how do i get to do this

please advice

thanks

**Ron Coderre** · 06-01-2011, 10:27 AM

Where is the monthly data stored
...same worksheet?
...same workbook, different sheet?
...another workbook?

What do you want to do with the matching information?
...sum it?
...display each item?
...something else?

**APPLEBEE** · 06-01-2011, 11:05 AM

Hi
I am working on SAP BPC
and have to retrieve data based on the selections in the EXCEL

therefore based onthe retrieved information from the formula of excel i must be able to dislay the data for those months as described in my post.

hope i have explained well

please let me know if i have not explained well
thanks

**APPLEBEE** · 06-01-2011, 12:13 PM

Hi
Ron

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 fetch only april and so on..

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

**MarvinP** · 06-01-2011, 12:46 PM

Hi Applebee,

See if using a Pivot Table helps with your need. See:
http://chandoo.org/wp/2009/11/17/gro...-pivot-tables/

**APPLEBEE** · 06-01-2011, 01:35 PM

hi

Gurus
I could get this resolved by using INDEX and MATCH combination
once explained as a solution for one of my problems by NBVC

thanks NBVC again

**NBVC** · 06-01-2011, 02:02 PM

You are welcome, Applebee, but.....

Your post does not comply with Rule 8 of our Forum RULES. Cross-posting is when you post the same question in other forums on the web. You'll find people are disinclined to respond to cross-posts because they may be wasting their time solving a problem that has been solved elsewhere. We prefer that you not cross-post at all, but if you do (and it's unlikely to go unnoticed), you MUST provide a link (copy the url from the address bar in your browser)to the cross-post. Expect cross-posts without a link to be closed a message will be posted by the moderator explaining why. We are here to help so help us help you!

Read this to understand why we ask you to do this