Forum Discussion
Sorting Problem
I build computers for myself and for friends, and I built a spreadsheet for comparing builds. I have a well developed system of determining a standardized point value to each component based on pric...
As variant
=LET(
data, $A$2:$F$16,
VSTACK(
{"Rank","Score","Build Name"},
HSTACK(
SEQUENCE(ROWS(data)),
SORT(CHOOSECOLS(data, {1,6}),2,-1)
)
)
)SergeiBaklan​ thats fantastic, thank you so much! I'll be digging into this to learn more about how the vstack and hstack commands work. I really appreciate this!
alternatively instead of another table just add the filters to that table (on Data tab) or Format as Table (on Home tab) and use the drop down filters to sort by that Totals column.
