Sort multiple columns descendant

Hi,

I'am looking for a function that sorts multiple columns descendant. Therefore, consider the following table:


Table_ex_sort.jpg

In the columngs A-C are different values. I wanna pick this values up and sort them descendant in column D, as showed in the Table (47,32,9,8,.....and so on). I think it it might be possible with a INDEX/MATCH function. Therefore, I tried the following function for cell D3 (32): =index($A$2:$C$9,MATCH(d3,$A$2:$C$9,-1),2) to search for the next smaller value than 47. But I got stuck and couldn't figure out if it's possible to solve the problem with a INDEX/MATCH combination. As a second step I wanna ignore duplicates.
Any advice would be much appreciated.

Thank you .

Patrick

Hello and welcome to the forum,

Could you upload an excel workbook because the example is not clear in the post?

Hi Patrick,

For future reference, we really dislike pictures here. It means that we have to create a workbook to reflect your workbook's structure from a photo.

Simplest answer I can think of is to use Large:

       A- B- C- D -E-- -------F-------
   1              Rank Sort descending
   2   82  1 68      1              94
   3   94 81 49      2              85
   4   37 23  2      3              82
   5   63 85 20      4              81
   6                 5              68
   7                 6              63
   8                 7              49
   9                 8              37
  10                 9              23
  11                10              20
  12                11               2
  13                12               1

       A- B- C- D -E-- ---------F---------
   1              Rank Sort descending    
   2   82  1 68      1 =LARGE(A$2:C$5,E2) 
   3   94 81 49      2 =LARGE(A$2:C$5,E3) 
   4   37 23  2      3 =LARGE(A$2:C$5,E4) 
   5   63 85 20      4 =LARGE(A$2:C$5,E5) 
   6                 5 =LARGE(A$2:C$5,E6) 
   7                 6 =LARGE(A$2:C$5,E7) 
   8                 7 =LARGE(A$2:C$5,E8) 
   9                 8 =LARGE(A$2:C$5,E9) 
  10                 9 =LARGE(A$2:C$5,E10)
  11                10 =LARGE(A$2:C$5,E11)
  12                11 =LARGE(A$2:C$5,E12)
  13                12 =LARGE(A$2:C$5,E13)

This thread shows some ideas on how to deal with Large and duplicates.

I agree, Excel becomes another more powerful program once you know how to work with arrays. They are extremely fast and allow you to do things that you never thought were possible.

Glad it all worked out.