Sort column by formula result

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
 
G

Guest

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

Guest

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

Similar Threads


Top