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
Bookmarks