CODEWITHSUNDEEP
excelsortingexcel-formula
Ybrad7
Ybrad7

Reputation: 11

Excel sort with formula in cell

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?

Thanks

Upvotes: 1

Views: 3891

Answers (1)

Wizhi
Wizhi

Reputation: 6549

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 you need to make the reference static.

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

enter image description here

Another solution could be to copy the area and paste in a new sheet as "values"

Upvotes: 2

Related Questions