Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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?
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sort isn't sorting correctly
Resolved
|
#3
|
|||
|
|||
Quote:
=(SUMPRODUCT(--(A1:A100<"")*(A1:A100<=A2:A101))=(COUNTA(A1:A100)-1)) should work |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sort isn't sorting correctly
Solved!
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Cells are not sorting correctly | Excel Worksheet Functions | |||
vlookups not sorting correctly | Excel Discussion (Misc queries) | |||
Numbers won't sort correctly. | Excel Discussion (Misc queries) | |||
Numbers won't sort correctly. | Excel Discussion (Misc queries) | |||
How to sort a list correctly? | New Users to Excel |