» 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:
- The McGraw-Hill 36-Hour Course in Finance for Nonfinancial Managers
- Investing in Real Estate, Fourth Edition
- Marketing Plans That Work, Targeting Growth and Profitability
- AWAKEN THE GIANT WITHIN : HOW TO TAKE IMMEDIATE CONTROL OF YOUR MENTAL, EMOTIONAL, PHYSICAL AND FINANCIAL
- Preparing the Marketing Plan (Ama Marketing Toolbox Series New Edition)
- Special Edition Using Microsoft Access 2002
No comments have been submitted.
