Results 1 to 2 of 2
  1. #1
    3 Star Lounger
    Join Date
    Aug 2001
    Location
    Cape Town, South Africa, South Africa
    Posts
    399
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Grouping (Excel XP)

    I need help in setting up the Groups in Excel. I have data with index numbers in Column A. I need it to group as per the values in Column A Example:

    1.1
    1.2
    1.3
    2.1
    2.2

    I need Excel to group on 1 & then on 2

    Thanks

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Grouping (Excel XP)

    You probably need to create an auxiliary column with the integer part of column A. For example: formula =Int(A2) in B2, then fill down. Use the auxiliary column for grouping.

Posting Permissions

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