Forum Discussion
Sorting Bins while keeping objects in them
Hello, I am trying to sort a list similar to the following. The bins need to be in order (1A,1B,1C,1D,1E, etc.) while the objects within the bin need to move with them. An example is supplied. Th...
As always, I set out to push Excel 365 to its limit!
= LET(
group, SCAN(0,list,
LAMBDA(grp,entry,
IF(LEFT(entry,1)="1",RIGHT(entry,1),grp))
),
SORTBY(list,group)
)
Basically, the idea is to use a new array to copy the group captions down and then sorts by group. With a cunning bit of conditional formatting