Results 1 to 10 of 10

Dynamic array to replace pivot table (sorting problem)

Threaded View

  1. #1
    Registered User
    Join Date
    04-30-2020
    Location
    New Zealand
    MS-Off Ver
    365
    Posts
    5

    Question Dynamic array to replace pivot table (sorting problem)

    Hello Excel comunity,

    I started playing with dynamic arrays to replace PivotTables. It s working well but I am struggling to order the data in the way I need.
    I wonder if is possible to make this Dynamic Array table without using the Auxiliar Table.

    Here is an example:

    1624666365574.png

    Formulas:
    1)=UNIQUE(Data[Customer])
    2)=SUMIF(Data[Customer],D4#,Data[Amount])

    3)=SORTBY(D4#,E4#,-1)
    4)=SUMIF(Data[Customer],D14#,Data[Amount])

    Thanks,
    Nicolas.
    Attached Files Attached Files
    Last edited by Noneto; 06-26-2021 at 01:25 AM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. pivot table sorting problem
    By elham.kh88 in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 11-25-2020, 11:04 AM
  2. [SOLVED] Pivot sorting problem when table has two columns
    By SwissExcel in forum Excel General
    Replies: 5
    Last Post: 12-08-2016, 03:39 PM
  3. Pivot Table Sorting Problem
    By Excel8449 in forum Excel Charting & Pivots
    Replies: 7
    Last Post: 08-09-2016, 02:49 PM
  4. Pivot Table Sorting Problem
    By kevsvette in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 12-02-2015, 03:24 PM
  5. sorting problem w/ pivot table
    By jyl7 in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 07-22-2013, 06:30 PM
  6. Pivot table- sorting with value filter problem
    By Masun in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 06-02-2013, 03:55 AM
  7. Regarding Pivot table sorting problem
    By ramki in forum Excel General
    Replies: 3
    Last Post: 08-06-2009, 02:36 AM

Tags for this Thread

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