CATEGORY: Excel Formula and Function VERSIONS: All Microsoft Excel Versions

Problem: 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$7)-ROW()+1,0)) Example: List_____Opposite List___Formula Result 1________5_______________5 2________4_______________4 3________3_______________3 4________2_______________2 5________1_______________1

Screenshot // Reversing The Order Of Values In A List

Rate this tip 1 2 3 4 5   RATING: 2.75   VIEWS: 11391 Email Tip Print Tip Add to My Tips

READER COMMENTS (view all comments)

No comments have been submitted.

REGISTERED USERS - Click here to post comments GUESTS (Click here to register) Name Comment Title Comments

The 22 Immutable Laws of Branding Microsoft Excel 2002 Simply Visual Cashflow Quadrant: Rich Dad's Guide to Financial Freedom The Laws of Money, The Lessons of Life: Keep What You Have and Create What You Deserve Windows XP All-in-One Desk Reference For Dummies Mortgages For Dummies®

RELATED MICROSOFT EXCEL TIPS

Create User Forms in Microsoft Excel Using Loops in VBA in Microsoft Excel The Best Shortcut Keys in Microsoft Excel Writing Your First VBA Function in Excel Add Combo Box to a Sheet in Microsoft Excel Formulas to calculate Loan payments in Microsoft Excel Array variables using VBA in Microsoft Excel Create an Amortization Schedule in Microsoft Excel Find duplicates items in combine columns in Microsoft Excel Vlookup Formula – Organizing the Data Table

• Excel VBA books
• Accounting books
• Business Plans
• MS Office books
• Taxes books