Microvellum Knowledge Network

Sorted Range Formula?

Any of know of a way to sort a range of values?




I'm messing around with creating a look up table for pulls/handles that will be used for a single formula generated hardware item. I think this might be easier to maintain than creating separate hardware items for each pull. 
However this means for the user to change the pull, they need to use a drop-down prompt instead of a hardware item prompt. Since we might end up with tons of different pulls, they need to be sorted in some way. 

I know I can use a RANGETOSTRING formula to generate the string, but there is no option to sort the list. The SORT() function that would be used to do this in excel doesn't seem to be recognized. 
I could also manually create and sort the list, but it would be nice to just use a formula. 

    MVU eLearning



    Grow Your Knowledge
    Follow along with RJ as he takes you on a journey to build your foundational knowledge of Toolbox.


      Follow us on:

               

        Google Review