View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
ekkeindoha ekkeindoha is offline
external usenet poster
 
Posts: 46
Default 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