need a formula to sort the table in descending order with some duplicated in the column.
I have this formula but it doesn't work due to duplicates. {INDEX($A$3:$A$60,MATCH(ROWS($H$3:H3),COUNTIF($H$3:$H$60,">="&$H$3:$H$60),0))}
Original Table
id Project Name traffic light FY 2017/18
31 Project A Red $104,378
16 Project B Red $-
53 Project C Red $18,767
28 Project D Red $-
20 Project E Red $5,000,000
69 Project F Red $5,000,000
85 Project G Red $323,753
0 0 0 $-
103 Project U Amber $52,064
6 Project J Amber $5,000,000
49 Project K Amber $52,644
59 Project L Amber $-
82 Project M Amber $35
2 Project N Amber $-
32 Project O Amber $1,671
9 Project P Amber $-
0 0 0 $-
Table with Formula
Id Project Name traffic light FY 2017/18
20 Project E Red $5,000,000
69 Project F Red $5,000,000
6 Project J Amber $5,000,000
85 Project G Red $323,753
31 Project A Red $104,378
49 Project K Amber $52,644
103 Project U Amber $52,064
53 Project C Red $18,767
32 Project O Amber $1,671
82 Project M Amber $35
16 Project B Red $-
28 Project D Red $-
0 0 0 $-
59 Project L Amber $-
2 Project N Amber $-
9 Project P Amber $-
0 0 0 $-
Bookmarks