Forum Discussion

gabby895's avatar
gabby895
Copper Contributor
Apr 26, 2024

Have a list automatically sort to group on another page in excel

Hi, I'm looking for a solution for billing for my company. Our current system: My boss writes down her work in a notebook as she completes it (ex. Client 1 Burger King 1 4/1/24). At the end of the mo...
Excel
PeterBartholomew1's avatar
PeterBartholomew1
Silver Contributor
Apr 26, 2024

gabby895 

It is possible to build the result as a stacked 'table of tables' using 365 but the exercise is not trivial and it depends both on your data structure (where did the dollar sums come from?) and the exact version of Excel.

=  LET(
    distinctClient,SORT(UNIQUE(Client)),

    properties, REDUCE("Property",distinctClient,LAMBDA(tbl,clnt,
      LET(
        pr, FILTER(Property,Client=clnt),
        spc, " ",
        VSTACK(tbl,pr,spc, spc)
      )
    )),

    count, REDUCE("Files",distinctClient,LAMBDA(tbl,clnt,
      LET(
        files, FILTER(countOfFiles, Client=clnt),
        subTotal, SUM(files),
        spc, " ",
        VSTACK(tbl,files,subTotal,spc)
      )
    )),

    HSTACK(properties, count)
  )

 

Resources