+ Reply to Thread
Results 1 to 2 of 2

Grouping

  1. #1
    Registered User
    Join Date
    12-13-2023
    Location
    Jasper, AL
    MS-Off Ver
    Microsoft 365
    Posts
    26

    Grouping

    Hello.. Let me say in advance thank you for your time and assistances.

    I need help on grouping. I have attached sales report. I want to be able to collapse the January and Feb Data to just show the subtotals for each month.
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    01-05-2013
    Location
    Singapore
    MS-Off Ver
    H&B2016 & H&B2021
    Posts
    3,059

    Re: Grouping

    Change the function_num in SUBTOTAL from 109 to 9, and redo the Grouping to exclude SUBTOTAL rows.
    Last edited by josephteh; 03-28-2024 at 03:33 AM.

+ 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. Replies: 1
    Last Post: 11-06-2020, 05:45 PM
  2. Replies: 0
    Last Post: 12-10-2015, 08:24 AM
  3. Replies: 4
    Last Post: 07-26-2014, 02:35 AM
  4. Want to get a Series with Grouping and Sub-Grouping based on 2 criterias.
    By e4excel in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 02-02-2011, 05:46 AM
  5. Grouping and grouping within groups
    By j-giesler in forum Excel General
    Replies: 1
    Last Post: 01-31-2006, 04:35 AM

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