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