Comments by JOEY VERANO JR.

JOEY VERANO JR. 3-Aug-23 1:48am View

To clarify, I'm trying to make a scoring system for a competition and I faced a problem when it comes to ranking the competitors.

An example can be found here: https://docs.google.com/spreadsheets/d/1lbnmHfW2Y2g8JR8PRZSaIRGgLM3n4rFvqZ2WOVjCQxU/edit#gid=0

The competitors should be ranked by these rules:

Final Score, if this is a tie, then by
TieBreaker, if this is also a tie, then they share a rank in final rank

I've been able to get to the 1st rule (where it rank the final score) but beyond that I'm out of knowledge.

Thank you!

JOEY VERANO JR. 3-Aug-23 1:20am View

I mean how to rank by multiple criteria in datagridview.

JOEY VERANO JR. 2-Aug-23 7:21am View

This is the last problem for my system. Hoping you understand my question. Thank you!

JOEY VERANO JR. 2-Aug-23 4:16am View

the logic is if the colB(RANK) does have a same score, the colD(Final Rank) will base on the tiebreaker score to rank it.

Based on my example in Col-A there are 2 ties which is 6.0. In Col-B it ranked with same place which is 3rd. The Col C(Tiebreaker) is also given together with Col-A.

In Col-D this will base on Col-B if there are same score and ranked it base on Col-C.

JOEY VERANO JR. 1-Aug-23 5:10am View

Hi! my question is how to rank the Column D (Final Rank), based on Column B(Rank) if ties score will base on Column C (TieBreaker). Thank you!

JOEY VERANO JR. 1-Aug-23 4:57am View

Thank you! please help me for the Column D (Final Rank), I want to rank it based on Column B(Rank) the ties score will base on Column C (TieBreaker)

Comments by JOEY VERANO JR. (Top 6 by date)