Hello,
I have a large numeric database (1000s of rows) - with a variety of numerical entries - values, percentages, etc - both positive and negative values.
I have macros to sort this data by columns - hi to low and low to hi.
However, the dataset always has some blanks (i.e. nulls - cells with no value entered - totally blank). It's usually because the data is not meaningful or unavailable.
I would like to find a way to ALWAYS have these blanks appear at the bottom of the sorts - both low to high and high to low. Basically below the sort results - and certainly not at the top. I'm happy to use conditional formatting, or code in the sort macro, or special characters, but can't find a way to do it.
Thanks so much!!
I have a large numeric database (1000s of rows) - with a variety of numerical entries - values, percentages, etc - both positive and negative values.
I have macros to sort this data by columns - hi to low and low to hi.
However, the dataset always has some blanks (i.e. nulls - cells with no value entered - totally blank). It's usually because the data is not meaningful or unavailable.
I would like to find a way to ALWAYS have these blanks appear at the bottom of the sorts - both low to high and high to low. Basically below the sort results - and certainly not at the top. I'm happy to use conditional formatting, or code in the sort macro, or special characters, but can't find a way to do it.
Thanks so much!!