ExcelBanter - How to sort cells with cell reference to get the same numbers?

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - How to sort cells with cell reference to get the same numbers? (https://www.excelbanter.com/excel-discussion-misc-queries/142609-how-sort-cells-cell-reference-get-same-numbers.html)

tina

How to sort cells with cell reference to get the same numbers?

When i sort a range of cells with cell references the result is not the same
numbers as before! So can i lock the cells from changing or do something else
to get the correct values?

All times are GMT +1. The time now is 04:09 AM.