ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Sort function not working correct (https://www.excelbanter.com/excel-discussion-misc-queries/263934-sort-function-not-working-correct.html)

nick

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 :)

Luke M[_4_]

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