league table

Hi there, It's been a while since I have posted here. I've had great help in the past so fingers crossed the same can be said for this time. Anyway, I have a fantasy premier league league which I am the league admin of. This season we are doing a head-to-head format which is posing new...

Hello all, I am working on a league table in excel which follows these set rules to determine the rank of the teams. Points obtained in all group matches; Goal difference in all group matches; Number of goals scored in all group matches; Points obtained in the matches played between the teams...

Hi everyone, I have a very basic understanding of Excel and have seen a few YouTube tutorials on formulas etc. however what I am looking for is some help on this fantasy league I've created, It's a 10 team league based on the 2021/22 Premier League fixtures. I want to be able to input the office...

I have a document with worksheets named WK01 to WK52. Each week I want to paste a series of data in to these worksheets. The layout and format will be exactly the same each time. Only the data will change. In column E of the week worksheets there will be a name of a product, column F the...

Dear members, My colleagues and I work together on projects each quarter. Each quarter there is one project Lead, and the rest of us (depending on our availability) are either a Support (i.e. we provide assistance) or else we're Passive (i.e. we're not really involved at all). Below is an...

Hello all, I'm pretty new to excel and i'm trying to setup a Boxing Prediction league. I did this last year but I had to quit early because it took to much time and I had to put the points one by one since I don't know much. Here's the situation... I'm setting up a Boxing prediction league. The...

Hi there, I have an excel document where people are going to score points based on sporting predictions. This document will be updated throughout the year. I am looking to have a 'league table' that updates based on when a players total points changes. Thanks

I am wanting to know how to live update a league table so that I don’t have to do it manually with the filter. Team is in column ‘A’, GD is in Column ‘R’ and PTS is in column ‘S’. There are 25 rows including the header row. I was the table to update with 3 priorities. First Priority is PTS in...

Hi Guys, My question is I need to calculate how many wins, draws and loses a team has by just putting the score in for Example: A B C D E 1 Kelmscott 2 v 1 Canning Vale 2 Gosnells utd 3 v 2 Armadale 3 Joondalup 0 v 2 Wanneroo 4 Armadale 0 v 1 Kelmscott...

I'm trying to create a 5 day golfing schedule for 12 players - this means there are 60 cells to fill. I want everyone to play with each other once but then have the minimum of repeats. I've tried the MRAND with INDEX which is great for each day's play but then find there are a lot of repeat...