orig_matrix = [-1 2 nan 2 3 4 -2; 100 nan nan -100 300 1000 0]';
     [matrix_sorted, id] = sort(orig_matrix ,1,ascend_descend);

ranking = [2 3 7 4 5 6 1; 3 6 7 1 4 5 2]
Many thanks!