» Reversing the Order of Values in a List
CATEGORY - Excel Formula and Function
VERSION - All Microsoft Excel Versions
We want to rearrange the contents of the list in column A in reverse order.
Solution:
Use the OFFSET, COUNTA, and ROW functions as shown in the following formula:
=OFFSET($A$2,COUNTA($A$2:$A$6)-ROW()+1,0))
Book Store:
Recommended Books:
- Marketing Management
- Good to Great: Why Some Companies Make the Leap... and Others Don't
- Millionaire Real Estate Mentor : The Secrets of Financial Freedom through Real Estate Investing
- Special Edition Using Microsoft Excel 2002
- Microsoft Office XP Introductory Concepts and Techniques
- F1 Get the Most out of Excel! The Ultimate Excel tip Help Guide
No comments have been submitted.
