How to check if the first letter of a string is in alphabetical order in a column

[gaose77777]

Hello, I want to check if the first letter of a string is in alphabetical order in a column, output 'Y' if it is otherwise output 'N'
Ex:

As it can be seen, the string in A6 starts with 'G' and A10 starts with 'B' which are not in alphabetical order in the previous cell.

 

[James006]

Hi,

In cell B2, you can test following Array Formula
=IF(AND(A2:A2>A1:A1),"Y","N")

 

[gaose77777]

Hi,

In cell B2, you can test following Array Formula
=IF(AND(A2:A2>A1:A1),"Y","N")

Hello, thanks for the reply.
When I applied the formula, it turned out like the following:

Only Cell 7 returned the correct value and the rest returned false. Is there anyway to fix these? Thanks!

 

[James006]

Hi,

A second attempt:
=IF(A2>A1,"Y","N")