MobileMobile | Continue

Excel Bar

Excel Bar

Your excel questions will be responsed by our excel experts within 24hrs.Our service is free.

 Forgot Pass?
 Register Now
Find
Hot Search: Vlookup Match VBA
12Next
Return Post new threads
View: 516|Reply: 10

Marking a leader board for my class

[Copy link]

2

Topics

2

Posts

8

Integral

Newbie

Rank: 1

Integral
8
Post on 2-9-2017 13:08:29 | All posts |Read mode
Hi,
I have a list of students and i would like some help to turn this data in to a colourful leader board.
Column E is there target progress
Column D is there progress so far
Column C is there deadline date
Could some one help me to turn this data in to a ranking system?

Thanks








  • Light Vehicle leaderboard.xls
    (28.5 KB, 0 views)
    Download

  • Reply

    Props Report

    34

    Topics

    1969

    Posts

    4182

    Integral

    Forum Legend

    Rank: 8Rank: 8

    Integral
    4182
    Post on 2-9-2017 18:34:52 | All posts



    You could try organizing the data with a pivot table.








  • Leader Board.xlsb
    (32.2 KB, 0 views)
    Download

  • Reply Support Opposition

    Props Report

    34

    Topics

    1969

    Posts

    4182

    Integral

    Forum Legend

    Rank: 8Rank: 8

    Integral
    4182
    Post on 2-9-2017 21:49:27 | All posts



    You could try organizing the data with a pivot table.








  • Leader Board.xlsb
    (32.2 KB, 5 views)
    Download

  • Reply Support Opposition

    Props Report

    34

    Topics

    1969

    Posts

    4182

    Integral

    Forum Legend

    Rank: 8Rank: 8

    Integral
    4182
    Post on 2-10-2017 00:38:44 | All posts



    You could try organizing the data with a pivot table.








  • Leader Board.xlsb
    (32.2 KB, 7 views)
    Download

  • Reply Support Opposition

    Props Report

    34

    Topics

    1969

    Posts

    4182

    Integral

    Forum Legend

    Rank: 8Rank: 8

    Integral
    4182
    Post on 2-10-2017 02:01:01 | All posts



    You could try organizing the data with a pivot table.








  • Leader Board.xlsb
    (32.2 KB, 9 views)
    Download

  • Reply Support Opposition

    Props Report

    34

    Topics

    1969

    Posts

    4182

    Integral

    Forum Legend

    Rank: 8Rank: 8

    Integral
    4182
    Post on 2-10-2017 04:14:04 | All posts



    You could try organizing the data with a pivot table.








  • Leader Board.xlsb
    (32.2 KB, 11 views)
    Download

  • Reply Support Opposition

    Props Report

    34

    Topics

    1969

    Posts

    4182

    Integral

    Forum Legend

    Rank: 8Rank: 8

    Integral
    4182
    Post on 2-10-2017 06:36:08 | All posts



    You could try organizing the data with a pivot table.








  • Leader Board.xlsb
    (32.2 KB, 13 views)
    Download

  • Reply Support Opposition

    Props Report

    34

    Topics

    1969

    Posts

    4182

    Integral

    Forum Legend

    Rank: 8Rank: 8

    Integral
    4182
    Post on 2-10-2017 08:20:50 | All posts



    You could try organizing the data with a pivot table.








  • Leader Board.xlsb
    (32.2 KB, 15 views)
    Download

  • Reply Support Opposition

    Props Report

    34

    Topics

    1969

    Posts

    4182

    Integral

    Forum Legend

    Rank: 8Rank: 8

    Integral
    4182
    Post on 2-10-2017 10:41:49 | All posts



    You could try organizing the data with a pivot table.








  • Leader Board.xlsb
    (32.2 KB, 17 views)
    Download

  • Reply Support Opposition

    Props Report

    34

    Topics

    1969

    Posts

    4182

    Integral

    Forum Legend

    Rank: 8Rank: 8

    Integral
    4182
    Post on 2-10-2017 14:03:25 | All posts



    You could try organizing the data with a pivot table.








  • Leader Board.xlsb
    (32.2 KB, 19 views)
    Download

  • Reply Support Opposition

    Props Report

    12Next
    Return Post new threads

    Points policy of this forum

    Archiver|Mobile|Small dark house|Contact us|Excel Bar

    GMT-5, 11-18-2017 05:10 , Processed in 0.193328 second(s), 20 queries .

    Powered by Discuz! X3

    © 2001-2013 Comsenz Inc.

    !fastreply! Top !return_list!