Find the Alphabetically Lowest Letter in a List
When the following formula is used to find the alphabetically lowest letter in List1 (column A):
An incorrect result of \"z\" is returned.
Use the CHAR, SMALL, and CODE functions as shown in the following Array formula:
To apply Array formula:
Select the cell, press .
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)
Search Engine Friendly URLs by vBSEO 3.6.0 RC 1