» Find the Alphabetically Lowest Letter in a List
CATEGORY - Excel Text Formulas
VERSION - All Microsoft Excel Versions
Problem:When the following formula is used to find the alphabetically lowest letter in List1 (column A):
=CHAR(SMALL(CODE(A2:A6),1))
An incorrect result of "z" is returned.
Solution:
Use the CHAR, SMALL, and CODE functions as shown in the following Array formula:
{=CHAR(SMALL(CODE(A2:A6),1))}
To apply Array formula:
Select the cell, press
Book Store:
Recommended Books:
- F1 Get the Most out of Excel! The Ultimate Excel tip Help Guide
- Investments + S&P Card + Powerweb + StockTrak discount coupon
- A Mathematician Plays the Stock Market
- Wall Street Journal Guide to Understanding Money and Investing
- Microsoft Windows XP Inside Out
- Who Moved My Cheese? An Amazing Way to Deal with Change in Your Work and in Your Life
No comments have been submitted.
