Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
sorting
I have a problem with sorting that when I sort my spreadsheet two columns do
not sort correctly one contains a workdays formula and the other a countif. The formulas work fine and there is no other problem or conflict. In the worksheet there is a workday formula that sorts just fine. What am I forgetting? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
sorting
Your formulas are probably changing cell references as they sort, so, if you
can, try replacing relative references with absolute references. -- HTH, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "Proto" wrote in message ... I have a problem with sorting that when I sort my spreadsheet two columns do not sort correctly one contains a workdays formula and the other a countif. The formulas work fine and there is no other problem or conflict. In the worksheet there is a workday formula that sorts just fine. What am I forgetting? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
sorting
Perhaps you have an empty column somewhere in your Data Field........Excel
won't skip-over a blank column. Vaya con Dios, Chuck, CABGx3 "Proto" wrote: I have a problem with sorting that when I sort my spreadsheet two columns do not sort correctly one contains a workdays formula and the other a countif. The formulas work fine and there is no other problem or conflict. In the worksheet there is a workday formula that sorts just fine. What am I forgetting? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
sorting
Thanks, I checked all the columns and there are no skips
"CLR" wrote: Perhaps you have an empty column somewhere in your Data Field........Excel won't skip-over a blank column. Vaya con Dios, Chuck, CABGx3 "Proto" wrote: I have a problem with sorting that when I sort my spreadsheet two columns do not sort correctly one contains a workdays formula and the other a countif. The formulas work fine and there is no other problem or conflict. In the worksheet there is a workday formula that sorts just fine. What am I forgetting? |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
sorting
You may be on to something, my problem is that I am referencing dates, the
first one is a variable date and the other is fixed. This is the formula =NETWORKDAYS('Nov. 06 Roll'!E34,('Nov. 06 Roll'!$AH$2),Lists!$A$54:$A$73) This column is a problem and then the next however the 3rd coulmn over works again just fine on the sort so it is not like an empty coulmn "RagDyer" wrote: Your formulas are probably changing cell references as they sort, so, if you can, try replacing relative references with absolute references. -- HTH, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "Proto" wrote in message ... I have a problem with sorting that when I sort my spreadsheet two columns do not sort correctly one contains a workdays formula and the other a countif. The formulas work fine and there is no other problem or conflict. In the worksheet there is a workday formula that sorts just fine. What am I forgetting? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Maintaining cell reference after sorting | Excel Discussion (Misc queries) | |||
Sorting Sorting Sorting | Excel Discussion (Misc queries) | |||
sorting non contiguous ranges | Excel Discussion (Misc queries) | |||
Advice sought: Multiple column sorting | Excel Worksheet Functions | |||
sorting number in ascending order | Excel Discussion (Misc queries) |