Multiple Criteria Ranks-Sumproduct, But skip duplicate ranks! & Reverse Ranks

[kul00]

I need a big help from experts. =]

After a day-research, I learned how to rank entries from multiple groups.

I ranked column D (A+B groups having highest C value) using sumproduct..But I need to skip duplicates in this column, and retain sequential orders. (1, 2, 3, 4...Not 1, 2, then 4!)

I need a formula for my expected output column (Column G)...If you can further help, reverse ranks columns will also make my job much easier.


-- removed inline image ---

 

[kul00]

I'm sorry not able to post my screenshot, new to this forum.

This is the example.

ColumnA B Value Expected-Ranks Ranks-Reverse
Group1 TEST1 6 2 2
Group1 TEST1 6 2 2
Group1 TEST2 2 1 3
Group1 TEST3 8 3 1
Group1 TEST3 8 3 1
Group2 TEST1 20 1 3
Group2 TEST1 20 1 3
Group2 TEST2 40 2 2
Group2 TEST2 40 2 2
Group2 TEST2 40 2 2
Group2 TEST3 60 3 1