Sorting in Wrapped Grid

Hello,

I am wondering if it's possible to sort values Left-Right AND Top-Bottom so that you wind up with a sorted grid. I have a large spreadsheet where all values need to be simultaneously in view, so we can't keep all values in a row or column, but I have not found a way to sort so that they remain in order in this grid form. I've taken a screen shot of an example of the type of sort function i'd like to preform: Unsorted grid values on the left, sorted on the right.

Sort(X&Y).jpg

Thank you for your help!

Hey shg,

That's a nifty solution! I should have mentioned- the values i'm trying to sort are Addresses- they start with numbers but contain letters, so they can't be sorted using the SMALL function, I don't think.
And even though in my example I showed a sorted grid next to an unsorted one, Ideally I'd like to just sort the existing cells without creating a fraternal twin.

Is this just not possible with excel?

Thanks,
Shane

Select the range to sort before run.

Please Login or Register  to view this content.