How to sort JavaScript array using multiple values?

Question

I have an array like this

[
     ["Adrian Garcia", "42"],
     ["Alberto Guglielmi", "42"],
     ["Alice Fung Yee Ng", "15"],
     ["Christopher Wilson", "4"],
     ["Claudio Meneghetti", "13"],
     ["Bahadir Tanriover", "15"],
     ["Baitinger Martin", "36"],
     ["Bill Cash", "15"],
     ["Brian Kuhlmann", "15"],
     ["Caesar Lima", "15"],
     ["Carl Tremblay", "42"],
     ["Aorta", "42"],
     ["Charles Harris", "15"],
     ["Chet Morrison", "15"],
     ["Chico Audi", "11"],
     ["Andreas Gemperle", "42"],
     ["Angel Burns", "42"],
     ["Arno Bosma", "42"],
     ["Chris Bailey", "15"],
     ["Chris Close", "1"],
     ["Christoph Martin Schmid", "42"],
     ["Ben Isselstein", "25"],
     ["Colin Thomas", "15"],
     ["Craig Cameron Olsen", "42"],
     ["Craig Easton", "42"]
]

I need to sort this array by numbers and also the name in ascending order. I find most of the solutions for sort by single value. But I need to sort by two values.

I need output like below.

[
    ["Chris Close", "1"]
    ["Christopher Wilson", "4"]
    ["Chico Audi", "11"]
    ["Claudio Meneghetti", "13"]
    ["Alice Fung Yee Ng", "15"]
    ["Bahadir Tanriover", "15"]
    ["Bill Cash", "15"]
    ["Brian Kuhlmann", "15"]
    ["Caesar Lima", "15"]
    ["Charles Harris", "15"]
    ["Chet Morrison", "15"]
    ["Chris Bailey", "15"]
    ["Colin Thomas", "15"]
    ["Ben Isselstein", "25"]
    ["Baitinger Martin", "36"]
    ["Adrian Garcia", "42"]
    ["Alberto Guglielmi", "42"]
    ["Carl Tremblay", "42"]
    ["Aorta", "42"]
    ["Andreas Gemperle", "42"]
    ["Angel Burns", "42"]
    ["Arno Bosma", "42"]
    ["Christoph Martin Schmid", "42"]
    ["Craig Cameron Olsen", "42"]
    ["Craig Easton", "42"]
]

*I tried most of the solutions* -- Show us *what* you tried. — George, Aug 13 '14 at 09:50
All that solutions are sort with only single value. Ex: myArray.sort(function(a, b) { return a[1] - b[1]; }); — RajivRisi, Aug 13 '14 at 09:53
@RajivRisi so you can use not single value in sort function :-) — Grundy, Aug 13 '14 at 09:53
possible duplicate of [Javascript, how do you sort an array on multiple columns?](http://stackoverflow.com/questions/2784230/javascript-how-do-you-sort-an-array-on-multiple-columns) — putvande, Aug 13 '14 at 09:56
OP, this has nothing to do with jQuery. Just plain JavaScript. — putvande, Aug 13 '14 at 09:57
@Aleksei Bulgak I get half solution from your code. I am trying to do sort by both values in ascending. Is it easier to change my array to this format something like this? [{"name":"AXXXXX","rank":12},{"name":"AMXXXX","rank":6}] — RajivRisi, Aug 13 '14 at 10:29

Aliaksei Bulhak · Answer 1 · 2014-08-13T10:35:34.777

2

try something like this:

   $(array).sort(function(first, second){
       if(first[0] < second[0]){return -1;}
       else if(first[0] > second[0]){return 1;}
       else if(first[0] === second[0]){
          if(parseInt(first[1]) < parseInt(second[1])){return -1;}
          else return 1;
       }
    });

DEMO

if you vant to sort by number first, use this:

   $(array).sort(function(first, second){
       if(parseInt(first[1]) < parseInt(second[1])){return -1;}
       else if(parseInt(first[1]) > parseInt(second[1])){return 1;}
       else if(parseInt(first[1]) === parseInt(second[1])){
          if(first[0] < second[0]){return -1;}
          else return 1;
       }
    });

edited Aug 13 '14 at 10:35

answered Aug 13 '14 at 09:56

Aliaksei Bulhak

6,078
8
45
75

Because this is only sorting it by name (first column). – putvande Aug 13 '14 at 10:00
are you sure. look at 3 else if – Aliaksei Bulhak Aug 13 '14 at 10:01
@putvande, firstly it sort using name and if only if name is the same it sort by value – Aliaksei Bulhak Aug 13 '14 at 10:02
Did you try it yourself? The name will never be the same so you will never get in that last `else if` statement. – putvande Aug 13 '14 at 10:02
Names are in alphabetic order, numbers are not in order: http://jsfiddle.net/xugnadz8/1/ (same code but different way of login so you can actually see what the array looks like). – putvande Aug 13 '14 at 10:07
@putvande, you kidding me. I write that if values(strings) not equal only then we check numbers – Aliaksei Bulhak Aug 13 '14 at 10:09
Again, `else if(first[0] === second[0]){` will never happen because there are no duplicates of names in there. Put an `alert` or a `console.log` in that if statement and see for yourself. – putvande Aug 13 '14 at 10:09
@putvande, yes. this is normal situation. you use second argument for sorting when first not unique. If you create list with duplicates of names and different numbers my algo sort them correctly. so I write correct algo and you downvote me. You can't sort by name and number at the same time – Aliaksei Bulhak Aug 13 '14 at 10:11
@putvande, so what. do you agree with my answer? – Aliaksei Bulhak Aug 13 '14 at 10:24
Yes your update orders them first by number and then by name. So I have changed my down in an upvote. – putvande Aug 13 '14 at 10:29

score 1 · Accepted Answer · answered Aug 13 '14 at 12:09

A shorter version would be just to use JavaScripts own sort function:

// First sort on number (second column)
array.sort(function(a, b) { return a[1] - b[1] });
// Then sort on name (first column)
array.sort(function(a, b) { return a[0] - b[0] });

which outputs as

[
    ["Chris Close", "1"],
    ["Christopher Wilson", "4"],
    ["Chico Audi", "11"],
    ["Claudio Meneghetti", "13"],
    ["Alice Fung Yee Ng", "15"],
    ["Bahadir Tanriover", "15"],
    ["Bill Cash", "15"],
    ["Brian Kuhlmann", "15"],
    ["Caesar Lima", "15"],
    ["Charles Harris", "15"],
    ["Chet Morrison", "15"],
    ["Chris Bailey", "15"],
    ["Colin Thomas", "15"],
    ["Ben Isselstein", "25"],
    ["Baitinger Martin", "36"],
    ["Adrian Garcia", "42"],
    ["Alberto Guglielmi", "42"],
    ["Carl Tremblay", "42"],
    ["Aorta", "42"],
    ["Andreas Gemperle", "42"],
    ["Angel Burns", "42"],
    ["Arno Bosma", "42"],
    ["Christoph Martin Schmid", "42"],
    ["Craig Cameron Olsen", "42"],
    ["Craig Easton", "42"]
]

Fiddle

Balachandran · Answer 3 · 2014-08-13T10:11:59.707

-1

I sorted by number

DEMO

 var arr=[
    ["Adrian Garcia", 42],
    ["Alberto Guglielmi", 42],
    ["Alice Fung Yee Ng", 15],
    ["Christopher Wilson",4],
    ["Claudio Meneghetti", 13],
    ["Bahadir Tanriover", 15],
    ["Baitinger Martin", 36],
    ["Bill Cash", 15],
    ["Brian Kuhlmann", 15],
    ["Caesar Lima", 15],
    ["Carl Tremblay", 42],
    ["Aorta", 42],
    ["Charles Harris", 15],
    ["Chet Morrison", 15],
    ["Chico Audi",11],
    ["Andreas Gemperle", 42],
    ["Angel Burns", 42],
    ["Arno Bosma", 42],
    ["Chris Bailey", 15],
    ["Chris Close", 1],
    ["Christoph Martin Schmid", 42],
    ["Ben Isselstein", 25],
    ["Colin Thomas", 15],
    ["Craig Cameron Olsen", 42],
    ["Craig Easton", 42]
]

for (var i = 0; i < arr.length; i++) {// No of times loop executed for given array

    for (var j = 0; j < (arr.length - i) - 1; j++) {   //  it wil save the one value each iteration  

        if (arr[j][1] > arr[j + 1][1]) {
            var temp = arr[j + 1];
            arr[j + 1] = arr[j];
            arr[j] = temp;
        }


    }

}
alert(arr);

edited Aug 13 '14 at 10:11

answered Aug 13 '14 at 09:55

Balachandran

9,567
1
16
26

That is half of the answer. – putvande Aug 13 '14 at 09:57
you sort by _string_ not a number – Grundy Aug 13 '14 at 09:58
@Grundy did you debug that code.i am using number not string – Balachandran Aug 13 '14 at 10:01
i mean that you have as result `1, 11,13 ... ` instead of `1,4...` – Grundy Aug 13 '14 at 10:02
@Grundy ya ,there is one mistake numbers also string changed to number ["Christopher Wilson",4], – Balachandran Aug 13 '14 at 10:10

How to sort JavaScript array using multiple values?

3 Answers3

DEMO