only have cells in an array that have values

[joeloyzaga]

I have an array that has elements with values and some elements that are empty. I'd like to ripple up the array only have the elements with values in the first part of the array and all the empty ones after that. since the array is 1 dimensional and its only a maximum of 22 possible elements is there a way I could just somehow sort it?

Thanks

Joe

[water]

Sure. Use _ArraySort and sort it descending.