Sort column by formula result

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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?
 
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top