Excel sort with formula in cell

621 views excel

When I have a formula in a cell (the list is about 8,000 long, I go to try and sort it from most to least, however when I do this it will not sort, I believe it is because there is a formula in the cell, is doing it the normal way of clicking on the cell(s) and using the ribbon. Is there a special way of doing it when a formula is involved?


answered question

1 Answer


Yes, by using absolute reference in your formulas, i.e. "$" for the rows, since you are changing the order of the rows when you filter.

The table below is sorted by "Largest to smallest."

enter image description here

posted this

Have an answer?


Please login first before posting an answer.