![]() |
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 :) |
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 ... 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 :) |
All times are GMT +1. The time now is 07:26 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com