Sorting of numbers

[Guest]

good day,
4 4 7 2200 ALF2288QR
4 4 4 980 AKE4567QR
4 4 5 980 AKE2255QR
2 2 1 0
Can anyone plse explain as where i'm making a mistake as on the formula
above it works out 100%, but as you will notice on the next one that it
does'nt work,even if I copy and paste.

11 11 5 5670 ee
9 9 5 5670 ee
7 7 7 5670 gg
6 6 7 5670 gg
1 1 9 4648 jj
1 1 4 4274 dd
1 1 3 3696 cc
1 1 3 3696 cc

si - plse note that I only copied the top part of the lines to show

 

[Stephen]

good day,
4 4 7 2200 ALF2288QR
4 4 4 980 AKE4567QR
4 4 5 980 AKE2255QR
2 2 1 0
Can anyone plse explain as where i'm making a mistake as on the formula
above it works out 100%, but as you will notice on the next one that it
does'nt work,even if I copy and paste.

11 11 5 5670 ee
9 9 5 5670 ee
7 7 7 5670 gg
6 6 7 5670 gg
1 1 9 4648 jj
1 1 4 4274 dd
1 1 3 3696 cc
1 1 3 3696 cc

si - plse note that I only copied the top part of the lines to show

Your post isn't clear. For example, do you have
4 4 7 2200 ALF2288QR
all in one cell, or in five?

If five cells, are the first four formatted as text or number (or even some
of each!)? (Widen the columns so you can see alignment clearly and turn off
all specific alignment. Text will then show as left-aligned, and numbers as
right-aligned.)

On what are you basing the sort?

Post back with what you find.

 

[Guest]

Good day,
the first 3 columns are the formula that was given to sort it out.Then it
gives me the three numbers descending - 2200,980,980.And for further ref the
last collumn.
In the first copy it works out as it should. But on the second copy I get
the idea that from collumn 3 there are already somthing wrong. What can the
problem be.

 

[Stephen]

Good day,
the first 3 columns are the formula that was given to sort it out.Then it
gives me the three numbers descending - 2200,980,980.And for further ref
the
last collumn.
In the first copy it works out as it should. But on the second copy I get
the idea that from collumn 3 there are already somthing wrong. What can
the
problem be.

Please explain what you mean by: "the first 3 columns are the formula that
was given to sort it out".
Which column or columns are you sorting by? Exactly what do you expect to
get, and what is different about what you actually get? I can't work out why
you say your first set of data are sorted properly, but not the second set.
Please explain.

 

[Guest]

good day,
The formulas I reffered to are as follows.
First collumn =RANK(K3,$K$3:$K$14)
Second collumn =IF(P17="","",P17+ROW()/12^12)
Third collumn
=IF(ROWS($1:1)>COUNT($Q$17:$Q$27),"",INDEX($H$3:$H$13,MATCH(SMALL($Q$17:$Q$27,ROWS($1:1)),$Q$17:$Q$27,0)))

What this formula does (it takes some scrambled numbers like 302,56,300,302
and sort it out to read 302,302,300,56.All this works out on both the copied
demo's I gave.The problem I've got are

302 a
56 b
300 c
302 d

On the first one I get a,d,c,b because it's next in line to the numbers
sorted out.
If I enter AA,BB,CC,DD it Gives me AA,AA,CC,BB due to the fact that the
first one concerning 302 are AA.
Can the problem be the fact that I enter it as AA