Topic: Excel help

[makemeacupoftea]

Hey ive made a league table etc etc. and was wondering how when i typed in the number of wins for a person, it would automatically calculate the points and show up in the points part

Cheers in advance

[Dave]

In your calculation cell type '=x*cellref'

Where x is the number of points for a win and cellref is the reference of the cell you type the number of wins in.

I take it you've never used Excel before?

If you want it to autosort the table with the leaders etc then i've no idea, it gets very complicated. That's why I used one I found on the net for the PES6 league.

[makemeacupoftea]

Not arsed about autosort or stuff, just want it so when i type in a number, e.g 9, it then appears in the point section as 27

And ive not used excel before and ill try what you said

cheers

[Dave]

Not arsed about autosort or stuff, just want it so when i type in a number, e.g 9, it then appears in the point section as 27

And ive not used excel before and ill try what you said

cheers

Well the above should work fine then.

[makemeacupoftea]

What i done?

[Dave]

You've created a formula that refers to a result that depends on the formula you've just made, so it can't find an answer.

[makemeacupoftea]

I'd appreciate it if you spoke english

[Dave]

In cell J10, type '=(D10*3)+(E10)'.

[Dave]

I'd appreciate it if you spoke english

If you look at the screengrab, you've put a reference to D10 in cell D10 itself. It can't find an answer.

[makemeacupoftea]

Dave you know that blowjob i said i'd gi...wait

Cheers it's working!

[Invicta_Toon]

best not get into the whole automatic sorting lark

[Dave]

All I meant originally is that if someone now goes ahead, you'll have to cut and paste their row into the correct position manually, as getting Excel to do it for you is complicated.

[Dave]

best not get into the whole automatic sorting lark

Exactly.

[makemeacupoftea]

Haha don't mind doing the sorting bit, just having the simple forumlas makes me get this done quicker

Cheers again, you sexy b******

[Invicta_Toon]

you couldn't of done it it in your head in the 20 minutes it's taken for this thread to run?

[Dave]

Might as well get it to do goal difference for you whilst you're learning the basics.

In cell I10 type '=G10-H10'.

[Invicta_Toon]

how s*** is Fragbite btw

[Dave]

how s*** is Fragbite btw

How can he lose without conceding?

[makemeacupoftea]

you couldn't of done it it in your head in the 20 minutes it's taken for this thread to run?

makes it easier for me to update in the future

edit: cheers dave 

edit: fragbite the prick dropped out

you seen what team i got put with, that consolecomps is a fix.

[Invicta_Toon]

[makemeacupoftea]

Jamies good at using excel

[Tooj]

I've done this before but can't remember how to do it anymore.

Say I update a spreadsheet is there any way that I can auto publish the same file as a .html on a shared location somewhere? As with work I have to update a certain report then save it as .html for other people to view on a shared location.

Just being a total lazy b****** really but I have done it before.

[Super Duper Branko Strupar]

Why don't you just whack it up on to Google docs?

[Tooj]

It's to go on one of the shared drives at work for the plebians to view.

[Super Duper Branko Strupar]

Sorted this? If it's a shared drive why can't you just upload the .xls file onto the drive for downloading?