Excel Anyone?

System
System Posts: 100,537 🤖 Admin 🤖
edited June 8 in Student general
Is anyone any good with excel?

What I'm tryig to do is a football league type table with 8 rows and 3 columns
Column B will contain 8 names and Column C will contain the points gained throughout the "season" as the points increase throughout the "season" I want the table to update so that the person will the highest number in column C is in position 1, column B row A

For e.g

Andrew 6
Dan 5
Jonathan 9

I want the table to automatically update when Jonathans points are changed, so now Jonathan should be top

If anyone has any ideas please can you let me know
Thanks

Comments

  • System
    System Posts: 100,537 🤖 Admin 🤖
    Re:Excel Anyone?


    Due to my limited Excel skills, I'd just go for a non-tehnical way; highlight columns B and C (I assume column A is numbered 1 to 8 for position?) then click,
    Data from the menu bar
    Sort
    Sort by Column C
    Descending

    Worked fine when I just quickly did it and it only took a few seconds.

    However, I also know how lazy I can be so would love someone to come up with an auto-sort formula!
  • System
    System Posts: 100,537 🤖 Admin 🤖
    Re:Excel Anyone?

    Yes Column A is numbered 1-8

    We did think of just sorting but again the same as you Rob were just lazy and have been sat here for days trying to figure out a formula to arrange it

    Fingers crossed someone can help
  • System
    System Posts: 100,537 🤖 Admin 🤖
    Re:Excel Anyone?


    That link that CJC posted in response to my query re changing negatives to postives probably has it.

    I downloaded something that does a lot more than that.

    http://forums.aat.org.uk/forums/posts/list/15372.page
  • System
    System Posts: 100,537 🤖 Admin 🤖
    Re:Excel Anyone?

    Cheers H,

    Ill have a look and see if i can find anything on there later

    Ive had a quick look and nothin stands out but ill look in more detail later
  • System
    System Posts: 100,537 🤖 Admin 🤖
    Re:Excel Anyone?


    Once Chris shakes off his hangover, I'm sure he'll be able to tell you.
  • System
    System Posts: 100,537 🤖 Admin 🤖
    Re:Excel Anyone?

    My hangover is well and truly over - so here you go.

    If you want the file, let me have your email address and i'll fire it off to you when I next have a minute.

    To see if it's what you want, I made a video of it in operation - tis on youtube.

    http://uk.youtube.com/watch?v=HE0sAEcKThA
  • System
    System Posts: 100,537 🤖 Admin 🤖
    Re:Excel Anyone?


    A classic from J!
  • System
    System Posts: 100,537 🤖 Admin 🤖
    Re:Excel Anyone?

    http://uk.youtube.com/watch?v=jYHRlBA_v0s
  • System
    System Posts: 100,537 🤖 Admin 🤖
    Re:Excel Anyone?

    It's the getting it to work with formulas that's the tricky bit.
  • System
    System Posts: 100,537 🤖 Admin 🤖
    Re:Excel Anyone?


    Why don't I get so many points in the new version? What did I do wrong?

    :cry:

Categories

Privacy Policy