Formula ranking based on column letter?????? Help Please

[SMOKEYSWORLD]

I have a spread sheet I am building for a competition. I have the formula working to rank with the values I need. But I need to see if there is a way that I can write a formula to only rank members in a group according to a row labeled class? I can send any and all info. Here is the formula I have currently but I would like it to instead of ranking a range of cells by number to rank a range of cells based on a letter that is assigned in the class column. Please let me know if that makes any sense or if you need more info. Thank you very much in advance.

=IF(ISNUMBER(K7),SUM(IF(ISNUMBER(K$7:K$87),(K7>K$7:K$87)/COUNTIF(K$7:K$87,K$7:K$87)))+1,"")

The column with the classification is Column B.

example.jpg

[Special-K]

Better to post the actual spreadsheet than a picture.
I for one don't fancy replicating any of that data if you've already typed it in once.

[SMOKEYSWORLD]

ScoreSheet.xlsx

There you go. Thank you for looking!

[bebo021999]

Do you mean ranking within each group?
Try this:
=SUMPRODUCT(($B$7:$B$85=B7)*($K$7:$K$85<K7))+1

[dilipandey]

Hi smokeysworld,

Please upload an excel workbook along with your expected results instead of an image. Thanks.


Regards,
DILIPandey
<click on below * if this helps>

[SMOKEYSWORLD]

dilipandey I did upload a spread sheet in my reply to special-k. Please take a look.

bebo, that formula does do what I want it too but I don't want it to rank the cell unless the cell in Column K has a value greater then 1.

[bebo021999]

So leaving blank where K <=1.

Please Login or Register  to view this content.

[SMOKEYSWORLD]

ScoreSheet.xlsxStill giving it a number. Here is the sheet:

[bebo021999]

May be:
=IF(K7<>"",SUMPRODUCT(($B$7:$B$85=B7)*($K$7:$K$85>1)*($K$7:$K$85<K7))+1,"")

[SMOKEYSWORLD]

That did it! Thank you so much. I will click the star!!