SORT RESULTS OF A FORMULA (this should be very simple)
 

I have a column with results of a formula.

When I try to sort it; insteat of doing it by the RESULT of the calculation;
it's sorting by the formula info that is inside the cell.

The autofilter didn't work eaither, there is any other option. Thank you.!!!

SORT RESULTS OF A FORMULA (this should be very simple)
 

can you give us a sample of your formula in the cell? I just did simple test
with a simple sum formula and it seemed to sort properly.

"HERNAN" wrote:

I have a column with results of a formula.

When I try to sort it; insteat of doing it by the RESULT of the calculation;
it's sorting by the formula info that is inside the cell.

The autofilter didn't work eaither, there is any other option. Thank you.!!!

SORT RESULTS OF A FORMULA (this should be very simple)
 

The formula is this one
=ROUNDDOWN((H9), 0) and is sorting by the H number
Example:
=ROUNDDOWN((H9), 0)

=ROUNDDOWN((H10), 0)

=ROUNDDOWN((H11), 0)

On the H Column there is another formula that says:

=Calculations!C15
=Calculations!C30
=Calculations!C45


"tim m" wrote:

can you give us a sample of your formula in the cell? I just did simple test
with a simple sum formula and it seemed to sort properly.

"HERNAN" wrote:

I have a column with results of a formula.

When I try to sort it; insteat of doing it by the RESULT of the calculation;
it's sorting by the formula info that is inside the cell.

The autofilter didn't work eaither, there is any other option. Thank you.!!!