Creating a Last man standing spreadsheet (Workbook)

im sure u downloaded the example file - ive been in touch a moderator before i posted i also let them know that it was a book more or less from scratch. with the results been entered manually it would be easier for the formula to do the won - drew lost as oppose to having to use a pull down menu. im open to suggestions or if someone wants to create something ive no prob with that. i think a helper column may be useful. Thank you for taking the time for ur suggestions and taking the time to reply

See attached:

I added helper columns to calculate the "lives" remaining:

In I5

=$C$1+VLOOKUP(INDEX(C5:H5,MATCH(B5,C5:F5,0)+2),{"Won",0;"Drew",-1;"Lost",-1},2,0)

in S5

=I5+VLOOKUP(INDEX(M5:R5,MATCH(L5,M5:P5,0)+2),{"Won",0;"Drew",-1;"Lost",-1},2,0)

This can be copied to following helpers

in K5

=IF(I5>0,$A5,"Out")

Copied to other "Name" cells

How do you want to handle "duplicate" choice of Team?

not looked at it yet but will in a min duplicate teams i suppose from the data sheet if it finds the same name twice not to allow it to be picked. i drew that template up in a week to avoid errors but am open to changes no problem there

is it poss to get the result sheet to update the sheet in the appropriate round? if not no harm

Do you mean tranfer scores form "Data" to "Results":

If so, it would be better to reverse this as in "Data" many people could choose the same team so a simple "LOOKUP" from "Data" to "Results" would retrieve the scores.

ya from results sheet to data sheet my error apologies

would it not be quicker to put the result in the results sheet as only 10 games in a week this would thein in turn feed the data sheet

any suggestions?

anyone got any other idea's?

in Data

c5

=IFERROR(MATCH(Data!$B5,Results!$A$5:$A$26,0),INDEX(Results!$A$5:$A$26,MATCH(Data!$B5,Results!$D$5:$D$26,0)))

in D5

=VLOOKUP($C5,Results!$A$5:$F$26,2,0)

in F5

=VLOOKUP($C5,Results!$A$5:$F$26,4,0)

in G5

=VLOOKUP($C5,Results!$A$5:$F$26,5,0)

Hi folks any updates to this?

Hi,
Don't know if this will help.
You can have up to 30 teams and 50 player's

Hi all
Just joined the forum as I was looking for a last man standing spreadsheet and this is perfect. It is protected, is there a pass word so I can edit the cells please?

Hi
Thank you for that, I have added in players the setup tab but in the pick tab it only has sufficient for 50 and if I try to add either copying formula etc, it messes everything up. is there an easy fix to have the table extended to say 90 players?