Ranking: funkcja POZYCJA

Funkcje statystyczne - Arkusz kalkulacyjny w liceum i technikum (sheet)

`=POZYCJA(C2;$C$2:$C$16)` podaje miejsce wyniku w rankingu (1 = najlepszy). Zakres rankingu ma adres bezwzględny, żeby po skopiowaniu w dół każdy uczeń był porównywany z całą listą. Równe wyniki dostają to samo miejsce.

{"sheets":[{"name":"Arkusz1","cells":{"A1":"Uczeń","B1":"Klasa","C1":"Punkty","D1":"Miejsce","A2":"Adam","B2":"3a","C2":"34","A3":"Beata","B3":"3a","C3":"41","A4":"Cezary","B4":"3a","C4":"27","A5":"Dorota","B5":"3a","C5":"45","A6":"Emil","B6":"3a","C6":"38","A7":"Filip","B7":"3a","C7":"41","A8":"Gabriela","B8":"3a","C8":"19","A9":"Hubert","B9":"3b","C9":"48","A10":"Iga","B10":"3b","C10":"36","A11":"Jan","B11":"3b","C11":"41","A12":"Kinga","B12":"3b","C12":"29","A13":"Leon","B13":"3b","C13":"44","A14":"Marta","B14":"3b","C14":"33","A15":"Nina","B15":"3b","C15":"50","A16":"Olek","B16":"3b","C16":"22","D2":"=POZYCJA(C2;$C$2:$C$16)","D3":"=POZYCJA(C3;$C$2:$C$16)","D4":"=POZYCJA(C4;$C$2:$C$16)","D5":"=POZYCJA(C5;$C$2:$C$16)","D6":"=POZYCJA(C6;$C$2:$C$16)","D7":"=POZYCJA(C7;$C$2:$C$16)","D8":"=POZYCJA(C8;$C$2:$C$16)","D9":"=POZYCJA(C9;$C$2:$C$16)","D10":"=POZYCJA(C10;$C$2:$C$16)","D11":"=POZYCJA(C11;$C$2:$C$16)","D12":"=POZYCJA(C12;$C$2:$C$16)","D13":"=POZYCJA(C13;$C$2:$C$16)","D14":"=POZYCJA(C14;$C$2:$C$16)","D15":"=POZYCJA(C15;$C$2:$C$16)","D16":"=POZYCJA(C16;$C$2:$C$16)"},"formats":{"A1":{"bold":true,"fill":"#e0e7ff"},"B1":{"bold":true,"fill":"#e0e7ff"},"C1":{"bold":true,"fill":"#e0e7ff"},"D1":{"bold":true,"fill":"#e0e7ff"}}}]}

Ładowanie interaktywnego edytora... Jeśli się nie pojawi, włącz JavaScript.

Wszystkie lekcje kursu Arkusz kalkulacyjny w liceum i technikum·Zaloguj się, aby zapisać postęp na koncie.