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...
I played with finding the SUM of the CODE and sorting but found it wasn't necessary.
My LAMBDA take ('list' being a named range for the unsorted list):
=DROP(SORT(HSTACK(SCAN("",MAP(list,LAMBDA(x,IF(ISERROR(SUM(LEFT(x))),"",x))),LAMBDA(a,b,IF(LEN(b)=0,a,b))),list),1,1),,1)