» Retrieving From List By Position
CATEGORY - Excel Formula and Function
VERSION - All Microsoft Excel Versions
Problem: Sorting List1 (column A) according to position numbers as shown in column B.
Solution:
Use the INDEX function as shown in the following formula:
=INDEX($A$2:$A$6,B2)
Example:
List1_______Position______Result
Mike________5_____________Rachel
Ron_________4_____________Mischelle
David_______3_____________David
Mischelle___2_____________Ron
Rachel______1_____________Mike
Book Store:
Recommended Books:
- Financial Statements: A Step-By-Step Guide to Understanding and Creating Financial Reports
- Rich Dad's Guide to Investing: What the Rich Invest in, That the Poor and the Middle Class Do Not!
- The Essential 55: An Award-Winning Educator's Rules for Discovering the Successful Student in Every Child
- Windows XP for Dummies
- Microsoft Excel VBA Programming for the Absolute Beginner
- Lower Your Taxes - Big Time! : Wealth-Building, Tax Reduction Secrets from an IRS Insider
No comments have been submitted.
