• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Appearance formula

G

guitarman

Member
Hi There
Long time no see been away for a few months But I was wondering if you could help me out with a formula to obtain player appearances through out the season so every time a player is selected to play in a tournament it chalks up against his name so by the end of the tournament season the best ones will have something like 18 or so. many thanks in advance.
Mike
 
Can you upload sample workbook with enough data? Without it, it's impossible for anyone to give you help on the formula.
 
Chihiro said:
Can you upload sample workbook with enough data? Without it, it's impossible for anyone to give you help on the formula.
Click to expand...
I have the format layout if that is any help So only four will be chosen for any one tournament and of course there will be changes for the next tournament if required.I am trying to upload this file but somehow when I press upload file it does not appear to be there baffled ?
 
guitarman said:
I have the format layout if that is any help So only four will be chosen for any one tournament and of course there will be changes for the next tournament if required.I am trying to upload this file but somehow when I press upload file it does not appear to be there baffled ?
Click to expand...
 

Attachments

  • tournament.xlsx
    129.5 KB · Views: 3
Something like attached (see Squad sheet)?

But I'm not sure about which table should the calculation be based on.

If attached isn't what you are looking for. Can you give detail of where to look for info and what the expected result should be?
 

Attachments

  • tournament.xlsx
    121.8 KB · Views: 9
As you can see I have tried copying a football appearance list but I don't know how it works how will i get it to increase the numbers every time a player is selected
 
guitarman said:
As you can see I have tried copying a football appearance list but I don't know how it works how will i get it to increase the numbers every time a player is selected
Click to expand...
Well Chilhiro I have sussed it out works great many thanks for your time and trouble have a great day and a brilliant life
mike
 
You must log in or register to reply here.
Back
Top