To reverse a range in Excel, it is fairly an easy job with SORTBY if you have dynamic array functions
=SORTBY(A2:A10, ROW(A2:A10), -1)
If you are still on drag and drop versions, here is the formula for drag and drop (Put this formula in a cell and drag it down)
=INDEX($A$2:$A$10, MAX(ROW($A$2:$A$10)-ROW($A2)+1))
The Excel file used can be downloaded from here – Tips & Tricks 197 – Reverse a Range
0pm5fe
jo7mnd
0hclcd
I was very pleased to find this web-site.I wanted to thanks for your time for this excellent read!! I definitely enjoying every little little bit of it and I've you bookmarked to take a look at new stuff you weblog post.
6nmmrt
2q9cnd
Hello there! This post couldn't be written any better! Reading this post reminds me of my good old room mate! He always kept chatting about this. I will forward this post to him. Pretty sure he will have a good read. Many thanks for sharing!
rcgstr
ccxmai