Oct 24 2018 10:41 AM
Hi all,
I'm trying to create an excel formula and don't know how to start. I know what I want it to do, but don't know how to make it work. Please see the attached PDF. Thanks!
Dean
Nov 02 2018 01:03 PM
Great! That's just amazing what you can do with Excel. I need to learn more for sure!
Dean
Nov 28 2018 01:33 PM
Hi,
I have one more request. Under the tab 6th-8th draft, I wanted to be able to add player requests that are linked with the player name to the player they want. Is that possible? So for example for Lauren Carter's team, in round 3, player Carter has a request for player Maunu, but that information is on the contact page. Can that work? Thanks!
Dean
Nov 28 2018 07:46 PM
Hi again,
You can use this formula for each request column:
=IFERROR(INDEX(CONTACT!I:I,MATCH(B4,CONTACT!B:B,0))&"","")
But it will return the full player name that corresponds to each member in the Contact sheet.
Nov 29 2018 03:22 PM
Oh my goodness. That's incredible! Thanks so much!
Dean
I have another problem that I wanted to see if you could help with. If not, that's ok. Attached is another Excel sheet. I want to be able to track teams playing against teams without having to copy paste everything each time. If I plug in a coaches name in game 1, I want the players rostered. Then when I put in the points for each player, I want that to put the number into the Totals tab so that can track the players points during the season. Is this something that Excel can do? Thanks!
Dean
Nov 30 2018 06:15 PM
Hi,
I'm sorry, but this is not easy!
You need to rearrange the data in Teams sheet to make the players to next coach head.
You can hide these extra columns or make their font color White.
After that, you can use some sort of functions to link them to the Game 1 sheet.
Please see the attached file.