Sorting a column with numbers into descending order
I try and do it but the cells then just cpme up with #ref! in them, why is it
doing this? |
Sorting a column with numbers into descending order
How did you try? Manually or with VBA?
It sounds as though the numbers in your column are results of a formula. On Oct 4, 9:43 am, wardle86 wrote: I try and do it but the cells then just cpme up with #ref! in them, why is it doing this? |
Sorting a column with numbers into descending order
This happens a lot if there is a column in the sort area that references another row and the row does not exist after the sort is completed. For example, if one column contains an accumulating amount, like a value in that row plus the total form the row above. After the sort the new top row will reference the row above it, but if that is the top row of the worksheet a row above will not exist and you will get that error in the top row, and it will propogate throughout. You could make the make the formulas a little more robust, or you can recreate them after the sort. Good luck. Ken Norfolk, Va On Oct 4, 1:17 pm, dan dungan wrote: How did you try? Manually or with VBA? It sounds as though the numbers in your column are results of a formula. On Oct 4, 9:43 am, wardle86 wrote: I try and do it but the cells then just cpme up with #ref! in them, why is it doing this?- Hide quoted text - - Show quoted text - |
All times are GMT +1. The time now is 01:38 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com