Dynamically generated table sorted by a column

**Gregb11** · 03-03-2022, 11:45 PM

EDIT: I did not see the other posts before I posted this...

Just a tweak to xk9128's formula to force the sorting:

=SORT(LET(x,Table1[Supplier],y,Table1[Spend],z,UNIQUE(x),CHOOSE({1,2},z,SUMIFS(y,x,z))),2,-1)

**tomas777** · 03-04-2022, 04:45 AM

It does not work. I have got #VALUE! error.

I do not know why.

**tomas777** · 03-04-2022, 04:50 AM

@Gregb11

It does not work. I have got #VALUE! error. I do not know why.

Dynamically generated table sorted by a column

LinkBack

Thread Tools

Rate This Thread

Display

Hybrid View

Re: Dynamically generated table sorted by a column

Re: Dynamically generated table sorted by a column

Re: Dynamically generated table sorted by a column

Thread Information

Users Browsing this Thread

Similar Threads

Enabling/disabling dynamically generated control via another dynamically generated control

Dynamically generated Shell command

[SOLVED] Duplicate a column of data from a table into new, sorted table

Stop equations updating dynamically when table is sorted/filtered

[SOLVED] Use VBA to download a dynamically generated image from the web.

creating pop-up menu from dynamically generated column values

Dynamically Generated Range using Macro

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions