Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 - |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
i am trying to fill a column with dates in descending order | New Users to Excel | |||
How to order chart in descending order of Freq? | Charts and Charting in Excel | |||
how can i change the order(ascending, descending) in a column? | Excel Discussion (Misc queries) | |||
CODE rectification while sorting in descending order | Excel Programming | |||
Date in descending order to come up automatically in a column? | Excel Worksheet Functions |