Sorting and empty cells

  • Thread starter Thread starter Terry
  • Start date Start date
T

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.
 
Terry,
I want to sort by a number of columns without the result
grouping those rows with empty cells.
Click to expand...

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
 
Back
Top