Sort Cells with formulas in 2007?

[RickM]

I am trying to sort cells that have formulas in them but I only want to sort those that have values. The cell formual is =IF(Input!C10="","",Input!C10). I need to sort on this column Only if there is a value not a formula. Now when I sort all the blank "" cell show up on top and the cell that have actual values are on the bottom of the sort. Any Suggestion?
Thanks

 

[Warship]

Where would you want the blanks to go? Blanks do sort to the top.
Posting examples of what you want will help get a better answer here.

Are you saying you have formulas AND values in Col C?
Or is it that you have formulas all the way down and some evaluate to values while others evaluate blank?

You could set up a helper column in D and put =If (C1<>"", D1=1,D1=2) then use col D as your first sort key.

 

[RickM]

Thanks for the reply:
This is what the data looks like where the formula returned values
Below 8/12/2011 Meals there are approx. 30 more rows where the formula returned blank.

ColA ColB ColC
Date Expense Type Amount
8/7/2011 Car Allowance $12.00
8/8/2011 Mobile phone $23.00
8/9/2011 Entertainment $33.00
8/9/2011 Park / Tolls $13.00
8/12/2011 Auto Costs $32.00
8/12/2011 Meals $321.00

I need to sort the cells that return values from range A3:C40
By Col B [Expense Type] first then by Col A (Date) next.
It should look like this:

8/12/2011 Auto Costs $32.00
8/7/2011 Car Allowance $12.00
8/9/2011 Entertainment $33.00
8/12/2011 Meals $321.00
8/8/2011 Mobile phone $23.00
8/9/2011 Park / Tolls $13.00

 

[Warship]

You could set up a helper column in D and put =If (C1<>"", D1=1,D1=2) then use col D as your first sort key.

This won't work? You could hide Col D