Sorting problem

S

StevenH

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

CLR

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
 
S

StevenH

It is not likely to be text. The numbers were created by applying
formula.
Below is a copy of part of the column. You can see that the numbers ar
on a downward slope, but many cells are out of order. If you look a
particular cells they have the right formula and have applied i
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
$1
 
R

RagDyeR

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!
=====================================================


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
 
S

StevenH

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

RagDyeR

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 !
----------------------------------------------------------------------------
-------------------

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.
 
S

StevenH

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