Hello,
I am trying to sort rows in A - Z order but include all blank cell sat the bottom.
My attached attempt (Macro) does sort correctly but the blanks are at the top instead of the bottom.
Would appreciate a solution please.
Hello,
I am trying to sort rows in A - Z order but include all blank cell sat the bottom.
My attached attempt (Macro) does sort correctly but the blanks are at the top instead of the bottom.
Would appreciate a solution please.
your "blank" cells are not blank
you can sort A-Z with blank cells at the bottom if blanks cells are really blank
Thanks sandy666.
My terminology is incorrect.
I still need the cells with the - in them for future use.
How do I sort A-Z as discussed above with these - included at the bottom please?
two steps:
- select all then sort by Z-A
- select range without "-" sign and sort by A-Z
maybe someone else will give you a formula or vba solution to sort with one step
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks