Check if column is sorted alphabetically

[APML]

Hi all, I have a table with a column of about 1800 entries .. I can sort the column in the table alphabetically a-z.
I'm looking for a formula that will confirm that the column in the table is sorted alphabetically or not (so I can use the answer elsewhere in the sheet).
Was hoping someone would be able to point me in the right direction

 

[bebo021999]

Like this?

Book1
	A	B
1	FALSE	TRUE
2	alpha	alpha
3	beta	apple
4	celcius	banana
5	apple	beta
6	banana	celcius
Sheet3

Cell Formulas
Range	Formula
A1:B1	A1	=AND(INDEX(A3:A6>=A2:A5,))

 

[Peter_SSs]

Like this?

You can omit the INDEX - at least in the OP's version.

22 09 22.xlsm
	A	B
1	FALSE	TRUE
2	alpha	alpha
3	beta	apple
4	celcius	banana
5	apple	beta
6	banana	celcius
Sorted

Cell Formulas
Range	Formula
A1:B1	A1	=AND(A3:A6>=A2:A5)

 

[APML]

You can omit the INDEX - at least in the OP's version.

22 09 22.xlsm
	A	B
1	FALSE	TRUE
2	alpha	alpha
3	beta	apple
4	celcius	banana
5	apple	beta
6	banana	celcius
Sorted

Cell Formulas
Range	Formula
A1:B1	A1	=AND(A3:A6>=A2:A5)

Hi, firstly thx for helping. I'm not understanding what I'm meant to be doing here

You can omit the INDEX - at least in the OP's version.

22 09 22.xlsm
	A	B
1	FALSE	TRUE
2	alpha	alpha
3	beta	apple
4	celcius	banana
5	apple	beta
6	banana	celcius
Sorted

Cell Formulas
Range	Formula
A1:B1	A1	=AND(A3:A6>=A2:A5)

Hi, firstly thx to both for the help, and it works well. just wonder 2 things:
Is there another formula that I can also use to confirm if the column was sorted z to a (as opposed to a to z)
And would it be the same formula if the column was numeric (% values) instead of a to z?

 

[Peter_SSs]

Is there another formula that I can also use to confirm if the column was sorted z to a (as opposed to a to z)

Yes, just swap the >= for <=

22 09 22.xlsm
	A	B
1	FALSE	TRUE
2	alpha	celcius
3	beta	beta
4	celcius	banana
5	apple	apple
6	banana	alpha
Sorted Z-A

Cell Formulas
Range	Formula
A1:B1	A1	=AND(A3:A6<=A2:A5)

And would it be the same formula if the column was numeric (% values) instead of a to z?

Give it a try and see.

 

[APML]

Yes, just swap the >= for <=

22 09 22.xlsm
	A	B
1	FALSE	TRUE
2	alpha	celcius
3	beta	beta
4	celcius	banana
5	apple	apple
6	banana	alpha
Sorted Z-A

Cell Formulas
Range	Formula
A1:B1	A1	=AND(A3:A6<=A2:A5)

Give it a try and see.

Fantastic, works well. Really appreciate your help

 

[Peter_SSs]

You're welcome. Glad we could help.