Spreadsheets

To see less ads Register or Login ----- £100k Fantasy World Cup --- FanTeam £30 of Free Fantasy Tickets Offer for New Customers

Spreadsheets

New Topic

Announcements

Replies

Views

Last post

FISO Super/Mini Leagues & Side Games 18/19 onwards

Last post by maxi123 « 21 Dec 2025, 01:28
Posted in FISO 'Champion of Champions'
Replies: 65
by Vid » 29 Jul 2018, 16:57 » in FISO 'Champion of Champions'
1

2

3
First post

A reminder to everyone regarding the Forum Rules regarding Leagues and Side Games, especially where cash and/ or prizes are involved!

FPL - ML &...

Last post

Ready. In.
65 Replies

1390527 Views

Last post by maxi123
21 Dec 2025, 01:28
FISO Forum Rules

Last post by Vid « 16 Aug 2020, 11:01
Posted in FISO Forum News
Replies: 5
by Vid » 10 Jan 2014, 09:52 » in FISO Forum News

First post

Forum Rules – updated 10th January 2014

These rules supersede the previous Forum Etiquette and come into force immediately and are linked to...

Last post

FPL's 2020-21 T&CS has included this new rule

12. Players (and Players on behalf of others and organisations) can establish mini-leagues in...

5 Replies

937208 Views

Last post by Vid
16 Aug 2020, 11:01

Topics

Replies

Views

Last post

Help required copying league table

Last post by Jester « 02 Dec 2020, 21:34
Replies: 7
by Jester » 30 Nov 2020, 21:37

First post

Last season I was able to copy/paste the league table from the TFF website straight into Excel (using cntl+C and cntl+V)
This season however, when I...

Last post

This is a real pain.
TFF have formatted the league table with paragraph deliminaters rather than tabs so it's treating every cell as a separate row....

7 Replies

4683 Views

Last post by Jester
02 Dec 2020, 21:34
Returning winner of two values (teams) in range of cells

Last post by Tacalabala « 18 Feb 2018, 20:20
Replies: 5
by Tacalabala » 16 Feb 2018, 22:44

First post

I've got a bit stuck trying to put together the spreadsheet for whoever takes on the FPL Rugby competition next.

I want the teams for the semi...

Last post

I'm afraid I'm using a very old version of office so I can't view your file to see exactly what you're trying to do.

Would something like this help...

5 Replies

4506 Views

Last post by Tacalabala
18 Feb 2018, 20:20
How to make column headings across multi workbooks the same

Last post by Jonathan « 07 Feb 2016, 22:25
Replies: 6
by Jonathan » 07 Feb 2016, 18:46

First post

Hello all.

I am trying to streamline something at work, and am having to use data supplied by our client. The problem is, their inconsistencies in...

Last post

I found a few scripts similar Jeff but problem is, I'm using a Mac and there are differences which don't work unfortunately.

6 Replies

4437 Views

Last post by Jonathan
07 Feb 2016, 22:25
Using multiple drop down menus to change calculation

Last post by Surprised « 09 Nov 2015, 16:38
Replies: 4
by stuboy » 09 Nov 2015, 13:13

First post

I'm trying to create a dynamic price proposal document, so depending on the inputs (from a drop down menu), the cost will change.

For instance,...

Last post

You won't data validation but a drop down box for the 3 multi choice questions as it's only yes or no. Then as jpk says IF statements in the grid to...

4 Replies

4054 Views

Last post by Surprised
09 Nov 2015, 16:38
Separate graphs from one dataset with few steps?

Last post by crispybits « 21 May 2015, 14:19
Replies: 7
by Ralfbergs » 20 May 2015, 09:59

First post

Not sure if the subject of the topic makes sense, but anyway, my question is:

Is it possible to take time series data, select them all and plot them...

Last post

Good luck Ralfbergs. My offer to help out with VA coding stuff remains open if you ever feel like it could be a good solution in the future. I...

7 Replies

4927 Views

Last post by crispybits
21 May 2015, 14:19
counting numbers only once

Last post by Tricky Tree « 13 Oct 2014, 18:58
Replies: 10
by barry » 13 Oct 2014, 14:59

First post

alright troops, got a massive spreadsheet (46k rows) - whats the best way to quickly check how many different numbers are in one column? i.e....

Last post

Go to data and choose remove duplicates?

10 Replies

5872 Views

Last post by Tricky Tree
13 Oct 2014, 18:58
Conditional formatting help reqd!

Last post by Surprised « 03 Oct 2014, 22:40
Replies: 30
by Jester » 02 Oct 2014, 16:52
1

2
First post

Right, hope someone can guide me here....?

I an using CF to highlight a cell if the date in it is more than a year old:

I'm using: Conditional...

Last post

Microsoft need to simplify formulas.

It should be as simple as:
If the date in A is over a year old and there is some paid stuff next to it then...
30 Replies

8968 Views

Last post by Surprised
03 Oct 2014, 22:40
Pimp my ride (excel version)

Last post by crispybits « 01 Aug 2014, 00:44
Replies: 6
by crispybits » 31 Jul 2014, 20:28

First post

OK so I gave it a deliberately misleading title, but I think I need a little help with this because I've been staring at it for so long that it's...

Last post

The deadline is always extended into the next week (7 day standard SLA) so thankfully that isn't a problem.

I've thoroughly tested it with various...

6 Replies

5600 Views

Last post by crispybits
01 Aug 2014, 00:44
hyperlink or Macro?

Last post by mike_d99 « 07 May 2014, 22:35
Replies: 10
by barry » 07 May 2014, 12:13

First post

I'm trying to think of a smart way to find folders on my work system. basically we have 100's of sites we store information about. each site has a...

Last post

Thanks for all comments, I think this is what I was trying to say :lol:

Not sure if this is entirely what you're looking for, but you could...

10 Replies

5333 Views

Last post by mike_d99
07 May 2014, 22:35
Creating a fixture list and league.

Last post by Mystery « 23 Jan 2013, 23:29
Replies: 8
by Deppy » 23 Jan 2013, 16:43

First post

Hi knowledgeable Fisoer's, I run a Prediction website and i thought for next season i would create a league format where people play against each...

Last post

I could wrote this in Excel but in the past I couldn't be arsed and used a free resource called leaguerepublic.com

No idea if it still exists though

8 Replies

5325 Views

Last post by Mystery
23 Jan 2013, 23:29
Excel drop-down lists - conditional?

Last post by Surprised « 15 Jan 2013, 20:45
Replies: 6
by crispybits » 14 Jan 2013, 23:05

First post

Right then peeps

I'm building an accounts spreadsheet for the charity I'm a trustee of, and however much I google I can't find a way of doing this...

Last post

Using data validation with the source as an INDIRECT formula works well

Set up a sheet with the main categories and under that put the sub codes and...

6 Replies

4617 Views

Last post by Surprised
15 Jan 2013, 20:45
excel query limitting formula to 2 decimal places

Last post by barry « 07 Dec 2012, 20:56
Replies: 6
by barry » 07 Dec 2012, 14:11

First post

ok so I know how to limit cells to 2 decimal places by formatting the cell, but when that cell is used in a calculation it appears to calculate the...

Last post

Takes me back to the days when I had to report the company's profit to the nearest £000. There was more time spent adding up & subtracting in the...

6 Replies

5209 Views

Last post by barry
07 Dec 2012, 20:56
Problem with VLOOKUP

Last post by Mystery « 01 Dec 2012, 19:23
Replies: 14
by StarMan » 01 Dec 2012, 11:45

First post

I am currently working on an Excel course I bought on the internet lately to improve my knowledge, and one of the things I really wanted to master...

Last post

A common mistake is that your left hand column that you're doing a lookup on has to be in some type of order e.g alphabetically.
No it doesn't if...

14 Replies

5990 Views

Last post by Mystery
01 Dec 2012, 19:23
Excel graphs

Last post by Surprised « 15 Nov 2012, 11:43
Replies: 18
by barry » 14 Nov 2012, 15:49

First post

afternoon troops,

wanting to produce a simple graph at work using 2 columns, dates and results

30.08.10
31.72

24.05.11
46.71

02.11.11
42.39...

Last post

It's nice to feel loved.

18 Replies

6261 Views

Last post by Surprised
15 Nov 2012, 11:43
WhoScored.com data

Last post by Arseshavin « 03 Oct 2012, 22:44
Replies: 8
by Arseshavin » 03 Oct 2012, 15:38

First post

Hi,

Does anyone know how I could extract the squad data in the link below from these tables to be able to present them in a different way. I just...

Last post

For sure.

One copy and paste would be fine, but twenty each week is a bit excessive.

Any further ideas? The firefox extension looks great if it...

8 Replies

7404 Views

Last post by Arseshavin
03 Oct 2012, 22:44
Spreadsheet Help - Please

Last post by Knulpuk « 03 Oct 2012, 16:06
Replies: 8
by wackojackouk » 21 Sep 2012, 23:25

First post

Hi chaps

I run a Fantasy League for some friends at work and friends of friends etc.

There are 57 teams in my league this year and I am having a...

Last post

C3 * D3 + E3

you don't even need the brackets, wait a minute is this one of these internet wind up things I have heard about :)

8 Replies

5175 Views

Last post by Knulpuk
03 Oct 2012, 16:06
Excel 101

Last post by stuboy « 21 Sep 2012, 11:38
Replies: 5
by stuboy » 21 Sep 2012, 11:14

First post

I'm sure this will be easy for your bods out there so going to call this Excel 101.

Question 1: I have 3500 email addresses in one column. However I...

Last post

After reading the first 2 posts I was about to say that the reason I called it excel 101 was so you would talk to me a like a child - when in fact...

5 Replies

4470 Views

Last post by stuboy
21 Sep 2012, 11:38
Planning calendar

Last post by Jester « 09 Apr 2012, 14:09

by Jester » 09 Apr 2012, 14:09

I am looking to create some kind of planning tool that will enable people to book time for, say, any of six different motor vehicles.

It would...

0 Replies

3893 Views

Last post by Jester
09 Apr 2012, 14:09
D'oh

Last post by blahblah « 04 Apr 2012, 22:03
Replies: 19
by blahblah » 04 Apr 2012, 16:13

First post

I have a simple problem for a wise monkey.

I want to turn a horizontal table into a vertical one - is it a simple Pivot? If so how etc?

1, I am...

Last post

That sounds like the high-tec version :lol:

19 Replies

6681 Views

Last post by blahblah
04 Apr 2012, 22:03
Copying and Pasting

Last post by eagle224 « 23 Mar 2012, 18:14
Replies: 5
by stuboy » 23 Mar 2012, 14:19

First post

I need some help - treat me with kid gloves as I don't really understand excel.

I have 1500 lines of data.

Each 31 lines of data equate to a...

Last post

Rather than touch the data, on sheet 2 cell A1 put =OFFSET(sheet1!$A$1,(ROW()-1)*31,0). Now copy this to A2, A3... etc until you have your list of...

5 Replies

4508 Views

Last post by eagle224
23 Mar 2012, 18:14
XML and Excel

Last post by Surprised « 11 Mar 2012, 21:35
Replies: 5
by crispybits » 11 Mar 2012, 19:44

First post

Ello peeps

I have a problem that I just want to check the viability of my solution for before I try and make it actually work....

I have a lot of...

Last post

I think the only way to run multiple web queries on one sheet is to eithey write a macro or set up each query separately with a different name. A bit...

5 Replies

5022 Views

Last post by Surprised
11 Mar 2012, 21:35
Changing VLookups to Index/Match

Last post by Rob « 22 Dec 2011, 19:40
Replies: 4
by cincirollers » 22 Dec 2011, 16:37

First post

With FPL again changing the format of their data, I've gone ahead and converted all my Vlookups to Index/Match so that I no longer have to worry...

Last post

The problem with this, I'm pretty sure, IS a degredation in performance as the formula will now look at EVERY row in a worksheet, when maybe it only...

4 Replies

4432 Views

Last post by Rob
22 Dec 2011, 19:40
Lookup query

Last post by Mystery « 09 Oct 2011, 13:11
Replies: 8
by barry » 08 Sep 2011, 23:00

First post

got a big spreadsheet with scores and shite, too big to print off/too complicated to email round, so basically trying to get a summary table done....

Last post

Sorry Barry didn't see your reply.

To the score add +(ROW()/10000)

8 Replies

5486 Views

Last post by Mystery
09 Oct 2011, 13:11
Making raw data easy to read

Last post by bspittles « 27 May 2011, 11:56
Replies: 17
by bspittles » 26 May 2011, 10:41

First post

I have 3 columns in a spreadsheet:

Student ID Course Block
001 ENG A
001 FRE B
001 GER D
002 GEO A
002 GER D
002 FRE D
002 ENG E
etc

It needs...

Last post

Ah well, I don't have a test sql server to try on. Best I can do

Your help was very much appreciated! The DECODE was a new one on me, so I've...

17 Replies

7065 Views

Last post by bspittles
27 May 2011, 11:56
Function help?

Last post by Mystery « 12 May 2011, 13:43
Replies: 74
by Jester » 24 Feb 2011, 10:54
1

2

3
First post

I've just started using Excel after about six years or so and am struggling to remember much of it....

Today I have the following problem to...

Last post

If you are at all unsure about sumif, look at countif first.

{} = array formulae = death. Avoid.

A SumIf as an array enables multiple sumifs. I...
74 Replies

17278 Views

Last post by Mystery
12 May 2011, 13:43
combining lists

Last post by bspittles « 07 Mar 2011, 08:34
Replies: 9
by barry » 02 Mar 2011, 22:52

First post

helping a friend out with a basic spreadsheet, but feel I (we :wink: ) could jazz it up a bit....

it's basically a 12 page (jan to dec) list of...

Last post

To keep it in the current format, you could give a name to each of the 12 totals cells, then add them up on a separate page. Inserting a row to add a...

9 Replies

5156 Views

Last post by bspittles
07 Mar 2011, 08:34
Excel spreadsheet problem

Last post by Billy Whiz « 26 May 2010, 21:55
Replies: 3
by Billy Whiz » 26 May 2010, 18:48

First post

Normally arrow keys move the cursor from one cell to the next. Suddenly, my arrow keys have stopped doing that: instead they move the whole...

Last post

Yep, I must have hit the scroll lock key by mistake. (Not that I even knew there was such a thing.) All sorted now.

Thanks very much :)

3 Replies

4612 Views

Last post by Billy Whiz
26 May 2010, 21:55
World Cup 2010 predictor

Last post by tictac « 17 May 2010, 18:47
Replies: 8
by bspittles » 04 May 2010, 15:08

First post

Anyone got a decent spreadsheet that allows you to enter predictions for the World Cup, and it works out the groups and knock out stages?

Last post

Hi All

Does anyone have a template that allows you to enter predictions and then enter actuals - which in result, would calculate points for getting...

8 Replies

8430 Views

Last post by tictac
17 May 2010, 18:47
Chart trouble on excel?

Last post by rossn13 « 06 May 2010, 17:15
Replies: 5
by Chrisharry12345 » 06 May 2010, 10:02

First post

Created some simple charts in excel 2007 yesterday, come back to them today and i cannot click on them? If i edit the data the graph changes...

Last post

Try copying the worksheet into the same workbook.
Also try logging in as administrator.

5 Replies

4815 Views

Last post by rossn13
06 May 2010, 17:15
Help with my Dream Team spreadsheet

Last post by Surprised « 07 Jun 2009, 08:56
Replies: 7
by StarMan » 06 Jun 2009, 00:03

First post

Just wondering if anyone can help

I run a Dream Team league at work and have been adding up the scores on a spreadsheet, I web query the player...

Last post

Glad to be of help Starman

7 Replies

5754 Views

Last post by Surprised
07 Jun 2009, 08:56
Excel query

Last post by Gonzague « 09 Apr 2009, 13:47
Replies: 3
by Gonzague » 09 Apr 2009, 13:32

First post

Work based query which is driving me mad.

I have a spreadsheet with various tabs on and want to get the key figures from each to come up with an...

Last post

Cheers lads! Quick response and quick solution!

3 Replies

4549 Views

Last post by Gonzague
09 Apr 2009, 13:47
Excel help please!

Last post by irishraider « 04 Feb 2009, 04:15
Replies: 5
by murf » 28 Jan 2009, 09:49

First post

Help please!

I did something to me spreadsheet last night (modern version of excel) and it is still showing today (old version of excel). Don't...

Last post

Select annoying columns - Click Data > Group and OUtline > UnGroup.

Annoying groupiig thing will dissapear. :D

Brilliant, sorted!

So how did I do...

5 Replies

6134 Views

Last post by irishraider
04 Feb 2009, 04:15

New Topic

Page 1 of 1

Return to Board Index

Forum permissions

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Login • Register

Spreadsheets

Forum permissions