Hi Keebellah,
How exactly do I exclude the winner in the scenario that I posted, to look for the runner-up? The function has to detect who has won the most games and then check the game duration. The range to rank on game duration should exclude whoever has won on the first criterion but that specific cell can change depending on input in the scoreboard right? I am using LARGE to check for the winner, but beyond that?
Thanks
Last edited by H1dd3v; 09-09-2018 at 10:36 AM. Reason: spelling error
I changed the format to the column B to a numeric format with a prefix
Column C is your's to continue with
---
Hans
"IT" Always crosses your path!
May the (vba) code be with you... if it isn't; start debugging!
If you like my answer, Click the * below to say thank-you
I am aware of what you did -- I already posted that I knew how to do that. Integrating C into the equation so as to combine both criteria is what I struggle with. I get that it is probably an easy fix but considering that you are aware that I don't know the answer and that I ask the question, could you not bash me for it please? I don't know how to do it.
Your usage of LARGE doesn't account for draws at all for the winner position by the way. Which is what I specifically asked.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks