+ Reply to Thread
Results 1 to 2 of 2

Best way to Summarize Table Quarter, week & State

  1. #1
    Forum Contributor
    Join Date
    07-17-2012
    Location
    India
    MS-Off Ver
    Excel 2007, 2010
    Posts
    643

    Best way to Summarize Table Quarter, week & State

    Hi,

    I need help and your expert view on making this to work..

    Issue : 1) I need to create a quarterly data in column. ( Column A, B, C and D )
    2) In the left side of the Sheet ( Column A ), I need 16 weeks of that quarter.


    What I want is a state drop down option in the sheet, by choosing which data of that state is displayed.

    Any Idea, how can i achieve this?

    Thanks
    Keep the Forum clean :


    1. Use [ code ] code tags [ /code ]. It keeps posts clean, easy-to-read, and maintains VBA formatting.
    2. Show appreciation to those who have helped you by clicking * Add Reputation below their posts.
    3. If you are happy with a solution to your problem, mark the thread as [SOLVED] using the tools at the top.

  2. #2
    Forum Guru Pete_UK's Avatar
    Join Date
    12-31-2011
    Location
    Warrington, England
    MS-Off Ver
    Excel 2007
    Posts
    20,510

    Re: Best way to Summarize Table Quarter, week & State

    Attach a sample workbook. Make sure there is just enough data to make it clear what is needed. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are demonstrated, mock them up manually if needed. Remember to desensitize the data.

    Click on GO ADVANCED and use the paperclip icon to open the upload window.

    View Pic

    Pete

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Calculate # of sales per week, month & quarter
    By AlcatrazT2 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 03-14-2013, 06:25 PM
  2. Is there an excel function summarize data according to Day of week?
    By Eaglekirk in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 02-23-2013, 07:02 PM
  3. [SOLVED] Find week within Quarter - more complex
    By realbum in forum Excel General
    Replies: 8
    Last Post: 08-21-2012, 11:02 PM
  4. Find Week in Quarter from Date
    By bh2 in forum Excel General
    Replies: 9
    Last Post: 08-17-2012, 04:42 AM
  5. [SOLVED] Looking for Fomula to display week in Current Quarter
    By Cra5h in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 07-13-2012, 03:21 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1