|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
May 17th, 2010, 05:19 PM
posted to microsoft.public.excel.misc
|
|||
|
|||
Sort function not working correct
I have three columns to my spread sheet. I need each row to maintain it's
data as it relates to each other. So I need to have column B and C to follow the information in A, when I sort by A, in each row. The problem I am encountering is that column B and C are changing values. B is a Year and C is a Number. When I sort...2009 might change to a 2010....and the # 9008 might change to 9118, or 1008. I highlight all 3 columns and all the rows and hit the sort by column A. It is unusual. I don't if there is something else I should be doing? Please help! Thank you  
|
|
#2
May 17th, 2010, 05:42 PM
posted to microsoft.public.excel.misc
|
|||
|
|||
|
Sort function not working correct
What are the formulas within B and C?
Example of weird sorting: http://spreadsheetpage.com/index.php...ng_oddity_bug/ -- Best Regards, Luke M "Nick" wrote in message news  I have three columns to my spread sheet. I need each row to maintain it's data as it relates to each other. So I need to have column B and C to follow the information in A, when I sort by A, in each row. The problem I am encountering is that column B and C are changing values. B is a Year and C is a Number. When I sort...2009 might change to a 2010....and the # 9008 might change to 9118, or 1008. I highlight all 3 columns and all the rows and hit the sort by column A. It is unusual. I don't if there is something else I should be doing? Please help! Thank you
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
