fixtures

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, I have a worksheet, "Comparison" that is fed by two other worksheets. This worksheet compares two different estimates, original and new. What I would like to do is add blank cells in either A:E or J:N so that my systems numbers in cells A and J match. I don't need anything else to match...

I am having trouble with this dependent drop down. My Wattage sheet is my master table. My ADD sheet is where I want to add the information. I would like to be able to have only the items listed in the other categories be available in my drop down on the ADD sheet. For example, if I choose CFL...

Hi there, I would like to create a macro that would save me so much time and also be fully correct as my current approach is quite manual. Let me describe what I require: Inputs; Team Name- this will list the teams taking part - this will range from 1-16 Number of Groups - this will be range...

I would like to be able to look up Column O from Table3 located in Columns AL-AN and to leave Column O blank if there is Column S is blank. All of the columns currently have a vlookup formula in them. I don't understand the lookup match function. I was using the following formulas but can't get...

Hi, I would like to create a spreadsheet that I can refresh and pull in each weeks English premier League fixtures, each week I would like to refresh this and see the weeks future fixtures. I have tried to use the import function from Data/From Web and selected the box with the table of...

Hi all, The BBC updated their sports pages overnight to a new format which puts my football predictor leagues in a bit of a pickle due to the way the scores etc all run on formulas driven by the BBC fixture format. I think you might call that an achilles heal - or just plain stupidity! What I...

I have been asked to run a one day Badminton Tournament 8 players against each other. What functions could best do the job of recording the results and transferring them to a league table that can show real time player’s positions.