» Retrieving From List By Position
CATEGORY - Excel Formula and Function
VERSION - All Microsoft Excel Versions
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:
- The New Financial Order: Risk in the Twenty-First Century
- Flipping Properties: Generate Instant Cash Profits in Real Estate
- Microsoft Windows XP Registry Guide
- Financial Peace: Revisited
- Absolute Beginner's Guide to Microsoft Office Excel 2003
- F1 Get the Most out of Excel! The Ultimate Excel tip Help Guide
No comments have been submitted.


