| 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 | |||
Linear Mode
