I have a table that assigns unit numbers based on quantities per year. The result is an array of unit numbers with some blank cells. I need to automatically convert the array to a single-column list (ascending order, skipping blanks).
I thought there was a way to do this with one of the SORT functions, but I don't even see SORT as an available function on my work computer (using Excel 2016).
I've attached an example of what I'm trying to do. Thanks in advance for your help!
McD
Bookmarks