Results 1 to 9 of 9

Thread: GROUPBY() and PIVOTBY()

Threaded View

Previous Post Previous Post   Next Post Next Post
  1. #5
    Site Admin VBAX Wizard Aussiebear's Avatar
    Joined
    Dec 2005
    Location
    Queensland
    Posts
    5,496
    Location
    Sorry edited post. To return the headers and the values I've selected the headers in the initial grouping so the formula now looks like this
    =GROUPBY(DataTable[[#Headers],[#Data],[AAA]],DataTable[[#Headers],[#Data],[FFF]],SUM,3,1)
    Attached Files Attached Files
    Last edited by Aussiebear; 04-17-2025 at 01:55 PM.
    Remember To Do the Following....
    Use [Code].... [/Code] tags when posting code to the thread.
    Mark your thread as Solved if satisfied by using the Thread Tools options.
    If posting the same issue to another forum please show the link

Posting Permissions

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