» Find the Alphabetically Lowest Letter in a List
CATEGORY - Excel Text Formulas
VERSION - All Microsoft Excel Versions
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:
- The 11 Immutable Laws of Internet Branding
- Final Accounting: Ambition, Greed and the Fall of Arthur Andersen
- Dictionary of Finance and Investment Terms
- Financial Statement Analysis with S&P insert card
- Wall Street Journal Guide to Understanding Money and Investing
- 422 Tax Deductions for Businesses and Self-Employed Individuals : You Get a Raise Every Time You Find a Legitimate Tax Deduction
No comments have been submitted.
