» 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:
- Who Moved My Cheese? An Amazing Way to Deal with Change in Your Work and in Your Life
- Investments + S&P Card + Powerweb + StockTrak discount coupon
- Treason: Liberal Treachery from the Cold War to the War on Terrorism
- Microsoft Word Version 2002 Step By Step (With CD-ROM)
- The Ernst & Young Business Plan Guide
- Definitive Guide to Excel VBA
No comments have been submitted.
