ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   sorting w/ blank cells (https://www.excelbanter.com/excel-programming/356371-sorting-w-blank-cells.html)

mark kubicki

sorting w/ blank cells
 
is there a way to sort a range, leaving all of the blank cells at the bottom
(rather than the top?)

thanks in advance,
mark



Tom Ogilvy

sorting w/ blank cells
 
Sort Descending

If you then want to sort ascending, reduce your range to exclude the blanks
and sort ascending.

--
Regards,
Tom Ogilvy

"mark kubicki" wrote in message
...
is there a way to sort a range, leaving all of the blank cells at the

bottom
(rather than the top?)

thanks in advance,
mark






All times are GMT +1. The time now is 03:35 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com