View original (French)

Excel: Podium

Edi-BurGer Posted messages 1 Status Member -  
Patrice33740 Posted messages 8400 Registration date   Status Member Last intervention   -
Hello,

I would like to create a podium (the top 3 essentially) from an Excel table.

I have 2 columns:

Column 1 = Candidate number
Column 2 = Candidate points

I would like the podium to be displayed on another page.

Thanks in advance for your help!

2 answers

  1.
    Raymond PENTIER Posted messages 58213 Registration date   Status Contributor Last intervention   17 482
     
    Easy: you use the RANK function and in the other sheet you simply put formulas like =Sheet1!C2
    --
    That's good, retirement! Especially in the Caribbean ... :-)
    ☻ Raymond ♂
    1
  2. Patrice33740 Posted messages 8400 Registration date   Status Member Last intervention   1 783
     
    You can adapt this example:
    http://www.cijoint.fr/cjlink.php?file=cj201010/cijKhDGVjM.xls
    --
    Best regards
    Patrice
    0