Can I find the lowest letter in a range of letters

Hi Eddie and welcome to the forum,

Look at the Char() and Code() functions. I believe they will answer your question. See attached for an example.

try this:

=CHAR(MIN(CODE(UPPER(C1:L1&CHAR(160)))))

Comfirmed with ctrl+shift+enter (not just enter)

This will return G no matter is it g or G

@zbor,

Why do you need the "&CHAR(160)" in your above formula?

Because it return #VALUE for blank cells. This way I add CHAR(160) at the end (I could put some other number only bigger than letters).
That way blank cell will become CHAR(160) and A will become A&CHAR(160) so it will take only A.

And if all are blank then it will still appear as blank (some other number might return something so I take 160).

This array formula also seems to work, allowing for blanks ...

Please Login or Register  to view this content.

Comfirmed with Ctrl+Shift+Enter not just enter.

Please Login or Register  to view this content.

Also works. (CSE of course)

I hate Char(160) as I can't see them and always think they are spaces when they aren't!

You won't see him here to unles all cells are blank.
But yes, your approach is also works.. I just avoid IF formula

It's perhaps being a bit over cautious, but if the range to analyse contains a number, a leading space, or character less than 65, both methods will return unexpected results, (see the attached workbook).

This array seems a little more robust

Please Login or Register  to view this content.

Comfirmed with Ctrl+Shift+Enter not just enter.

However EddieLFC has marked the thread [SOLVED], so I'm assuming the problem doesn't arise.

It won't be a problem if numbers are lower than letters.
Probably there is no numbers at all... If there is, hope user will come back with that issue.

tgallap, first, welcome to the forum. Please review the forum rules (link at the top), there aren't many but posting your question on another's post is not good (forum rule #4).
feel free to start your own post, they are free.
and if you feel info on this post is relevant copy the url and paste it into your post.
again, welcome to the forum.