» 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:
- Microsoft Word Version 2002 Inside Out
- Positioning: The Battle for Your Mind
- The Complete Book of Business Plans: Simple Steps to Writing a Powerful Business Plan (Small Business Sourcebooks)
- Special Edition Using Microsoft Access 2002
- Advanced modelling in finance using Excel and VBA
- F1 Get the Most out of Excel! The Ultimate Excel tip Help Guide
No comments have been submitted.
