Sorting problem
 

I have a number of worksheets on three different computers in which the
sorting ends up flawed. So most cells will be right, but it might go
$50, $49, $48, $49, $47, $46, $48 etc. Is there a mistake I am likely
making to produce these results, a way that would help to fix this, or
something I should check with the cells to see what the problem might
be. Is this a common problem?


--
StevenH
------------------------------------------------------------------------
StevenH's Profile: http://www.excelforum.com/member.php...o&userid=32590
View this thread: http://www.excelforum.com/showthread...hreadid=523892

Sorting problem
 

Probably one of the $48 is actually a number and the other, although it
looks like a number is actually TEXT....try copying the good $48 that sorted
properly and pasteing it over the bad $48 that did not sort properly and
sort again.....

Vaya con Dios,
Chuck, CABGx3


"StevenH" wrote in
message ...

I have a number of worksheets on three different computers in which the
sorting ends up flawed. So most cells will be right, but it might go
$50, $49, $48, $49, $47, $46, $48 etc. Is there a mistake I am likely
making to produce these results, a way that would help to fix this, or
something I should check with the cells to see what the problem might
be. Is this a common problem?


--
StevenH
------------------------------------------------------------------------
StevenH's Profile:
http://www.excelforum.com/member.php...o&userid=32590
View this thread: http://www.excelforum.com/showthread...hreadid=523892

Sorting problem
 

It is not likely to be text. The numbers were created by applying a
formula.
Below is a copy of part of the column. You can see that the numbers are
on a downward slope, but many cells are out of order. If you look at
particular cells they have the right formula and have applied it
properly.

$41
$36
$31
$39
$38
$28
$28
$34
$25
$27
$30
$24
$25
$21
$20
$24
$23
$25
$24
$29
$22
$23
$18
$23
$15
$18
$16
$16
$16
$17
$14
$16
$15
$16
$17
$15
$14
$16
$15
$15
$14
$13
$15
$15
$13
$11
$15
$11


--
StevenH
------------------------------------------------------------------------
StevenH's Profile: http://www.excelforum.com/member.php...o&userid=32590
View this thread: http://www.excelforum.com/showthread...hreadid=523892

Sorting problem
 

Are you saying that you're sorting cells that contain formulas?

Check your formulas to make sure that *some* of the cells referenced in the
formulas are not changing due to being relative references instead of
absolute references.

--

HTH,

RD
================================================== ===
Please keep all correspondence within the Group, so all may benefit!
================================================== ===


"StevenH" wrote in
message ...

It is not likely to be text. The numbers were created by applying a
formula.
Below is a copy of part of the column. You can see that the numbers are
on a downward slope, but many cells are out of order. If you look at
particular cells they have the right formula and have applied it
properly.

$41
$36
$31
$39
$38
$28
$28
$34
$25
$27
$30
$24
$25
$21
$20
$24
$23
$25
$24
$29
$22
$23
$18
$23
$15
$18
$16
$16
$16
$17
$14
$16
$15
$16
$17
$15
$14
$16
$15
$15
$14
$13
$15
$15
$13
$11
$15
$11


--
StevenH
------------------------------------------------------------------------
StevenH's Profile:
http://www.excelforum.com/member.php...o&userid=32590
View this thread: http://www.excelforum.com/showthread...hreadid=523892

Sorting problem
 

The cells I am sorting contain a formula under the numbers, eg., row 7
is =sum(q7:u7); row 8 is =sum(q8:u8). Checking the cells down the
column reveals that the underlying formulas respond to the proper row.


--
StevenH
------------------------------------------------------------------------
StevenH's Profile: http://www.excelforum.com/member.php...o&userid=32590
View this thread: http://www.excelforum.com/showthread...hreadid=523892

Sorting problem
 

Change your formulas to:

=SUM($Q$7:$U$7)
=SUM($Q$8:$U$8)
etc.

And post back with the results after sorting those formulas.
--

Regards,

RD
----------------------------------------------------------------------------
-------------------
Please keep all correspondence within the Group, so all may benefit !
----------------------------------------------------------------------------
-------------------

"StevenH" wrote in
message ...

The cells I am sorting contain a formula under the numbers, eg., row 7
is =sum(q7:u7); row 8 is =sum(q8:u8). Checking the cells down the
column reveals that the underlying formulas respond to the proper row.


--
StevenH
------------------------------------------------------------------------
StevenH's Profile:
http://www.excelforum.com/member.php...o&userid=32590
View this thread: http://www.excelforum.com/showthread...hreadid=523892

Sorting problem
 

Thanks for the suggestion. I tried it, but it simply reproduced the
numbers in the first cell down the line. I tried other variations, but
they produced bizarre numbers and did not sort properly. I tried
changing the column to numbers and running the original formula. No
luck. I am reasonably sure the formula is right because many have
followed the formulas (to determine values in a fantasy baseball
league) and it has worked for them.


--
StevenH
------------------------------------------------------------------------
StevenH's Profile: http://www.excelforum.com/member.php...o&userid=32590
View this thread: http://www.excelforum.com/showthread...hreadid=523892

Sorting problem
 

If you wish, you can send me the sheet.

ragdyeratmsndotcom

--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------

"StevenH" wrote in
message ...

Thanks for the suggestion. I tried it, but it simply reproduced the
numbers in the first cell down the line. I tried other variations, but
they produced bizarre numbers and did not sort properly. I tried
changing the column to numbers and running the original formula. No
luck. I am reasonably sure the formula is right because many have
followed the formulas (to determine values in a fantasy baseball
league) and it has worked for them.


--
StevenH
------------------------------------------------------------------------
StevenH's Profile:
http://www.excelforum.com/member.php...o&userid=32590
View this thread: http://www.excelforum.com/showthread...hreadid=523892