ExcelBanter - Sort isn't sorting correctly

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Sort isn't sorting correctly (https://www.excelbanter.com/excel-discussion-misc-queries/452260-sort-isnt-sorting-correctly.html)

GARYWC

Sort isn't sorting correctly

Is there a formula/function (not a macro!) that I can use to verify whether the cells are in ascending order?

GARYWC

Sort isn't sorting correctly

Resolved

mikerickson

Quote:

Originally Posted by GARYWC (Post 1626052)

Is there a formula/function (not a macro!) that I can use to verify whether the cells are in ascending order?

A formula like
=(SUMPRODUCT(--(A1:A100<"")*(A1:A100<=A2:A101))=(COUNTA(A1:A100)-1))

should work

GARYWC

Sort isn't sorting correctly

Solved!

All times are GMT +1. The time now is 11:58 PM.