Sorting Data Range With Formulas

  • Hi all,


    I need some help on a sorting macro.


    I have a range C11:O104 I would like to sort Ascending first from Column E then Column D


    Only problem is that all cells have formulas so when this macros is run, I get blank cells sorting as well and they end up at the top.


    I have tried to remove blank cells, but I do not want to delete the rows OR the formulas from the cells.


    Can anyone help sort my range with blank cells that contain formulas?


    HELP!
    Tayler

    Tayler [the blue fox] :thanx:

  • Re: Sorting Data Range With Formulas


    If you don't want the blank rows to be sorted to the top, what do you want Excel to do with them if they can't be deleted either? Are they simply blank cells waiting for data to be entered later?

  • Re: Sorting Data Range With Formulas


    You can add a helper column that tests whether the cell is blank, and sort by that first.

    [SIZE=1]Entia non sunt multiplicanda sine necessitate.[/SIZE]