Scores posted on 'games' sheet, sent to 'matches & games' sheet, find winner or indicate 'tie', and show names. I haven't been able to always indicate 'tie' when it's with player on same team. Found winner using 'max', but can't seem to show name of that winner. This is a re-post, since my attachment first time didn't; attach that is. Here's hoping.
I can't figure out what you are doing, but you might want to look up INDEX. The syntax for index is = INDEX(This Range, This row,This Column). You are apparently using max to find the winning score. You can use MATCH to find out which row it is on (Match will only find the first occurrence) and you should know what column has the name.
One spreadsheet to rule them all. One spreadsheet to find them. One spreadsheet to bring them all and at corporate, bind them.
A picture is worth a thousand words, but a sample spreadsheet is more likely to be worked on.
Hi
Welcome to the forum.
Games sheet
Total Matches
Cell AR10Copy downFormula:
Please Login or Register to view this content.
Total Scores
Cell AR27Copy downFormula:Please Login or Register to view this content.
Matches Rank
Cell AU10Copy downFormula:Please Login or Register to view this content.
Cell AU7Formula:Please Login or Register to view this content.
Cell AT10Copy downFormula:Please Login or Register to view this content.
Cell AT7Formula:Please Login or Register to view this content.
Same as Score Rank by change number to 29:39
Matches & Scores sheet
Matches Winner
O24Formula:Please Login or Register to view this content.
T24Formula:Please Login or Register to view this content.
Same as Scores Winner by change to 29:39.
This up to 5 players tie? Should be plenty!
See the files
all the best
Last edited by micope21; 03-30-2016 at 11:56 AM.
To help you by my post? it would be nice to click onto say "Thank you".
If you are happy with a solution to your problem?
Click Thread Tools above your first post,
select "Mark your thread as Solved".
Hi Dflak,
Looks like a great spreadsheet, but I'm still trying to wade through it. I'm really finding out how little I know about Excel. Bear with me.
Thanks for the help. I'm sure I'll find my way eventually.
Cheers,
Matcutter
Hi micope21,
After being a little mindboggled, I finally saw how it worked. The 'matches' function didn't work at first, because you sent it to the lower set of cells for the names, but (of course) I neglected to put the names down there. So, I redirected to the names above and it worked! Thank you!
However, I'm still confused. Is there a function called 'dummy', or does that refer to me? Rightfully so. If it really would find the 'winner' or 'tie', I'd like to figure how to do that. So far, too dense to figure it out.
Oh, by the way, I don't expect more than 3 ties, but might in future when I attempt a tournament with 24 or 36 players.
Thanks again for the assistance.
Cheers,
Matcutter
Last edited by matcutter; 03-31-2016 at 11:45 PM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks