Excel User Group
Microsoft Excel blogs, forums, files. Read, ask questions, provide answers.

Excel- Group different column

Latest post Fri, Feb 12 2010 10:38 AM by Alan Hutchins. 1 replies.
  • Fri, Feb 12 2010 10:09 AM

    • Rek
    • Not Ranked
    • Joined on Fri, Feb 12 2010
    • Posts 1
    • Points 21

    Excel- Group different column

    I am trying to group/select few column in a big table , like column c , f, i, l,,,, along with the value and information in the rows.

    What need is ,from the table (example) , I would like to select 1 or 2 options from the drop down list.

    When I select this any of this , figures / information in the rows also should be selected along with this drop down list.

    Does any one has idea?

    I am not so familiar with vlookup, but I can try.

    Can any one help me?

                       
      Dropdown list 1  April Dropdown list 2 Sales  
      May Income  
      June Expeneses  
       
       
       
    Detail 1 Detail 2  Detail 3 Detail 4 Sales
    Apr
    Income
    Apr
    Expenses
    Apr
    Sales
    May
    Income
    May
    Expenses  May
                       
                       
                       
                       

     

    Thanks

    • Post Points: 21
  • Fri, Feb 12 2010 10:38 AM In reply to

    Re: Excel- Group different column

    Hi,

    Can I check your requirement?

    Will you want to show all rows - regardless of your drop down selections?

    Is it the case that you may want to select Sales, and see all the months, or select a month and see all the values, as WELL as selecting a month and a value (e.g. Sales for Feb)?

     

    • Post Points: 5
Page 1 of 1 (2 items) | RSS
Copyright Excel User Group and the relevant contributors, 2009. All Trade Marks acknowledged. This site is a peer-to-peer site and NOT affiliated in any way to Microsoft Corp. All rights reserved.