Sorting and empty cells

[Terry]

I want to sort by a number of columns without the result
grouping those rows with empty cells.
The empty cells are spread over a number of rows and
columns.

 

[Bernie Deitrick]

Terry,

I want to sort by a number of columns without the result
grouping those rows with empty cells.

Then you will either need to sort by smaller groups or come up with some logic of how to deal with the empty cells. Usually, in
cases like that, you can use a formula in another column, and sort based on the formula. Or, you can change which column is your
primary/secondary/tertiary sort key.

HTH,
Bernie
Excel MVP