hello everyone, i need a few favor/ guide how to solve thisDUPLICATE SCORE.xlsx DUPLICATE SCORE.zip
hello everyone, i need a few favor/ guide how to solve thisDUPLICATE SCORE.xlsx DUPLICATE SCORE.zip
It might be possible to do this with formulas only, but I don't know how. Would you consider a VBA solution?
You said "with tie breaker" but you show a place to put 3 names. Do you want to list all names with a tying high score, or just one name after a tie-breaker is applied? What is your tie-breaker algorithm?
"what if i change other highscore number, can the name also change?" What is the "other" highscore number? What name would you want to change?
For your case, you can use formulaFormula:Please Login or Register to view this content.
Try this ARRAY formula in C15,
=IFERROR(INDEX($A$2:$A$9,SMALL(IF($B$2:$G$9=LARGE($B$2:$G$9,1),ROW($B$2:$G$9),""),ROW($A1))-ROW($B$2)+1),"")
Then drag down.
ARRAY formula should be confirmed with Ctrl+Shift+Enter Keys together.
YESS YESS .... TQ every body for support, u all save my Headache hahaha tq tq tq, problem solve hahahaha im sooo happy, tq all
If your question has been answered please mark your thread as "Solved" so that members will know by looking at the thread title that your problem is solved. Go to the menu immediately above your first post to the thread and click on Thread Tools. From the dropdown menu select "Mark this thread as solved..."
If a member helped you solve your problem, consider adding to their reputation by clicking on the star icon below their name.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks