Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sorting of numbers
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sorting of numbers
"ekkeindoha" wrote in message
... 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. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sorting of numbers
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. "ekkeindoha" wrote: 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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sorting of numbers
"ekkeindoha" wrote in message
... 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. "ekkeindoha" wrote: 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 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. |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sorting of numbers
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$2 7,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 "Stephen" wrote: "ekkeindoha" wrote in message ... 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. "ekkeindoha" wrote: 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 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sorting high numbers from low numbers between two rows | New Users to Excel | |||
Sorting - cells containing numbers, numbers and letters | Excel Discussion (Misc queries) | |||
Sorting numbers with differing numbers of digits | Excel Discussion (Misc queries) | |||
sorting numbers | Excel Discussion (Misc queries) | |||
sorting numbers | Excel Discussion (Misc queries) |