» Find the Alphabetically Lowest Letter in a List

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 and simultaneously press .

Book Store:

• Excel VBA books
• Accounting books
• Business Plans
• MS Office books
• Taxes books

VIEW ALL BOOKS

Recommended Books:

• Excel 2002 Power Programming with VBA
• Microsoft Office XP Introductory Concepts and Techniques
• Special Edition Using Microsoft Office XP
• Microsoft Word Version 2002 Inside Out
• Microsoft Excel Version 2002 Step by Step
• Guide to Financial Reporting and Analysis

Email Tip

Print Tip

Add to My Tips

Rate This Tip

1 2 3 4 5

Rating: 3.00     Views: 10550

No comments have been submitted.

Click here to post comment

For Registered Users

Click here to Regiser

For Guest

Name

Comment Title

Comments