Sort column by formula result
 

I need to sort a column by the result of the formula in that cell...Is this
possible?

Basically I have a column full of dates (which are generated by formulas
related to cells within the column and other cells), and I need to be able to
sort the column by the result of the formulas.

Thanks
Ryan

Sort column by formula result
 

it depends on the formulas, some will sort, others won't.

"Ryan" wrote:

I need to sort a column by the result of the formula in that cell...Is this
possible?

Basically I have a column full of dates (which are generated by formulas
related to cells within the column and other cells), and I need to be able to
sort the column by the result of the formulas.

Thanks
Ryan

Sort column by formula result
 

I only use simply formulas like cell a1 is a date, then cell b1 would be
=a1+12 (days)

any idea how i can make this work?

"bj" wrote:

it depends on the formulas, some will sort, others won't.

"Ryan" wrote:

I need to sort a column by the result of the formula in that cell...Is this
possible?

Basically I have a column full of dates (which are generated by formulas
related to cells within the column and other cells), and I need to be able to
sort the column by the result of the formulas.

Thanks
Ryan

Sort column by formula result
 

if you sort both columns this equation would sort.
if you do only column b you would not see a difference, you should use
absolutye references such as
=$A1 + 12

"Ryan" wrote:

I only use simply formulas like cell a1 is a date, then cell b1 would be
=a1+12 (days)

any idea how i can make this work?

"bj" wrote:

it depends on the formulas, some will sort, others won't.

"Ryan" wrote:

I need to sort a column by the result of the formula in that cell...Is this
possible?

Basically I have a column full of dates (which are generated by formulas
related to cells within the column and other cells), and I need to be able to
sort the column by the result of the formulas.

Thanks
Ryan