View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Luke M[_4_] Luke M[_4_] is offline
external usenet poster
 
Posts: 457
Default 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 :)