LinkBack URL
About LinkBacks
I want to flip the data B2:B9 upside down.
How to do that?
I want to flip the data B2:B9 upside down.
How to do that?
In the adjoining column, enter 1,2,3,4 down the column and then sort (high to low) on that column.
ChemistB
My 2?
substitute commas with semi-colons if your region settings requires
Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)
Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble
If you want a formula, this will do it
Formula:
Please Login or Register to view this content.
I don't believe Excel will let you rotate regular text more than 90 degrees in either direction off horizontal. You might be able to rotate WordArt and Shapes with text to 180 degrees (I haven't tried it) in design mode.
Any code provided by me should be tested on a copy or a mock up of your original data before applying it to the original. Some events in VBA cannot be reversed with the undo facility in Excel. If your original post is satisfied, please mark the thread as "Solved". To upload a file, see the banner at top of this page.
Just when I think I am smart, I learn something new!
Originally Posted by ChemistB
I filled A2:A9 with numbers then tried to sort and got this error;
"This operation requires the merged cells to be identically sized."
?
Where do I write this formula?If you want a formula, this will do it
Formula:Please Login or Register to view this content.
Custom Sort works. Thank you very much for the answers.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks