Using RANK with COUNT qualifications

[bobbby1949]

I have 28 members that score points for each event that they participate during a ten week schedule. I have a SUM column for the total points accumulated. I also have another SUM column showing only the seven highest points scored. I also have a column using COUNT showing the number of events they have received points. I also have a standings (RANK) column.

Since all members do not participate in each week's event, the count numbers vary. So, I need to have another column that ranks the the standings where there are a minimum of 7 (COUNT) scores posted. I will call it a "Qualified Standings" column.

I want the final standings to only use the scores when there is a minimum of 7 posted, and after at least 7 scores are posted.

I hope I have explained this well enough for you to understand.

[daddylonglegs]

Assuming you have the number of events in A1:A28 and the scores to rank in B1:B28 you can use this formula in C1 copied down

=IF(A1<7,"",SUMPRODUCT((A$1:A$28>=7)*(B$1:B$28>B1))+1)

[bobbby1949]

daddylonglegs, it's amazing how well you can understand what someone is trying to accomplish with questions that probably deserve better wording and explanation.

It worked perfectly. In fact, I was able to go with one less column too.

Thank you very much...again.