I have several projects that sort data from greatest to least
(descending). That is, nothing is considered greater than a million.
Of about 4000 rows between a third and a half are blank (no count).
I need the maximum values/count at the top of the list, but Excel puts
these empty cells at the top of the list. As a result I have to do a
lot of moving of large groups of data around to put the empty/blank
cells at the bottom of these lists -- a real time consuming pain.

Is there a way to have Excel treat empty/blank cells as having lower
values than cells with values?

I assume I could fill all empty cells with zeros but this will clutter
the reports up a lot, so I'd rather not do that.

jim