player

Here has got to be a better way to do this. This takes forever and gives me a run time error. I want to change the value of the cell only if it is NOT one of the four IFS. I probably want a find and replace but only if it is on condition it is not one of the four values (Player Tier, Veteran...

Hi there, Greetings from Denmark :) I need help to complete this case/file, I do for my local sports club. So here is what I need. When a new player has to be entered into the sheet. A team is assigned by selecting a team from the drop list in "select team" Column.. So fare so good...

Hi Guys. I am trying to make a fantasy football team selector that will look at the list of my players and pick the best option for the position i want to pick and i am wondering if you guys could help. I have a sheet (named squadsheet) with all my player's ratings in each and every position...

Hi. I am trying to use the aggregate to find the minimum fantasy football player score for a single game. I am using the function as shown in this video https://youtu.be/Oxj-wMGjAW0?t=340 . My code as of this point is: =AGGREGATE(15,6,ActData!$Q1:$Q20000/(ActData!$B1:$B20000=[@Player]),1)...

Hi Is there a way to declare the windows media player as an object or variant only by the default references? Its not in a form. If yes, how? :eeek: Im on excel 2010.

Hey All, I am in some desperate need of help for a Ryder Cup (Match play) style golf tournament. We are doing a combination Ryder Cup team format over the course of 3 days, 8 players, teams of 2, as well as have an individual component to scoring our Net for a cash prize at the end. I have...

I have a wee macro for creating a new sheet based on the value of a textbox. I want to test that the textbox value does not contain any of the prohibited characters for sheetnames, namely : \ / ? * [ ]. I'm guessing that I could probably use a big NOT LIKE statement but is there a neater way...

Hi, what my confusing title is trying to ask is this: I want to calculate average points for a player when another player isn't playing. So in this list: DATE PLAYER PTS 1-1-2017 Player1 10 2-1-2017 Player2 15 2-1-2017 Player1 18 What...

Hi, I'm trying to change the IF statements in cells H5 through H10 as well as the same formulas (targeting the different name) in column J by using IF and then COUNTIF. The IF statements need to account for all changes in the dropdowns in E6, E7 and E8. For example, if I wanted to see how a...

I am statistician for football team. I have created a list of team stats for the entire team, but am wanting to create separate lists for individual categories such as rushing and receiving, but only include those individual players with at least one attempt. The following is a sample from...

I know how to sort a table of data based on different criteria, but I was wondering if there is a way I can custom sort a single column based on multiple criteria from other columns. I'd like it in a macro, because I want it to update the sort every time I submit data from a userform. Here's...

<tbody> A B C D E F 1 Name Score Rank Score Name 2 Player A 1 1 5 Player E 3 Player B 2 2 4 Player D 4 Player C 3 3 3 Player C 5 Player D 4 Player H 6 Player E 5 4 2 Player B 7 Player F 1 Player G 8 Player G 2 5 1...

<tbody> A B C D E F G H I J 1 Home Team Home Score Away Score Away Team Scorer 1 Scorer 2 Team A Team B Team C 2 Team A Team B Player A1 Player B1 Player C1 3 Team C Team D Player A2 Player B2 Player C2 4 Player A3 Player B3 Player C3...

Hi everybody. I have a table of data that tracks scores for players on a team. the data is separated by dates. how would I use the AverageIF function to average the last 5 scores for a player from the data set? thanks

Hello, I am trying to automatically populate the results of my NFL Fantasy Draft into the below table, which is on 1 tab in my workbook. <tbody> Draft Order Player 1 2 3 4 </tbody> In the chart below (which is on another sheet in the workbook), I was hoping there was an easy...

The pool Match consists of 7 games and the 4th game is always a doubles game. Teams must have at least 6 players so 2 players could play a doubles game as well as their singles game. Please refer to the spreadsheet link. There are two tables, one for fixture and results details and the other for...

I'm creating a fantasy drafting tool to use in fantasy football. I have it set up how I want it, but I am lost with all things VBA. Currently, I'm just recording Macros on each checkbox click, but I'm pretty sure some VBA code would work a lot better. Background on the tool, it is a VBD...

Hi, I run a sports club (cricket) and keep a tally of all the stats for the team. I am trying to create alerts when certain cells reach certain levels for the first time. Each year has a spate sheet with all the stats with a sheet totalling all the stats. So for example, over the last 4 years...

I'm interested in analysing some fantasy football data to see the consistent high points scorers each season. I want to be able to easily view points totals per year per player from multiple tables, one for each year. I can't seem to work out the best way to merge the data so i can see player...

Hello, I'm running a round robin tournament with following table: <style type="text/css"><!--td {border: 1px solid #ccc;}br {mso-data-placement:same-cell;}--></style> <tbody> Group A 1 2 3 4 5 6 7 8 MW ML FW FL FD FA POS 1 Player 1 0 2 1 0 2 2 2 4 3 9 8 1 0.53 4 2 Player 2 2 2 2 2 2 1...