Formula to RANK groups of Values and return letter

Hi Folks
I have grouped values that need to be ranked and have the top values return B+? where ? is the value by which it is clear of the next highest value and B-? where -? is the value it is from the TOP ranked value.

http://www.excelforum.com/excel-form...-b-values.html

http://www.excelforum.com/excel-form...-b-values.html

In the second link above Ace_XL kindly provided the following formula:

Formula:

Please Login or Register  to view this content.

The formula is for where there is a blank divider row between groups-

I now need a formula to use Col A as the divider of the groups-

Each group has a unique ID as shown in Col A in the attached Workbook-

Again, I need to be able to pull it across as well as down.

Cheers
hammer

Admin note: Title modified slightly so the thread would open

Relatively easier

In G2

=IF(E2=MAX(INDEX(($A$2:$A$25=$A2)*E$2:$E$25,0)),"+"&E2-LARGE(INDEX(($A$2:$A$25=$A2)*E$2:E$25,0),COUNTIFS($A$2:$A$25,$A2,E$2:E$25, MAX(INDEX(($A$2:$A$25=$A2)*E$2:$E$25,0)))+1),E2-MAX(INDEX(($A$2:$A$25=$A2)*E$2:E$25,0)))

Copy down

Got to love easier!

Champion's effort yet again Ace_XL

Regards
hammer