VLOOKUP - HLOOKUP
VLOOKUP - Classes -three firstplace classes from all classes

For acompliched number of pionts write firstranked classes seperatly

for points earned members rite three firstranked classes from all classes .VLOOKUP function acount for reserched values in range and write content next row choosen collum. first parametrs function values witch is needed (in this case 1)then range in witch is needed value,third parametar collum is used by doing write next row (in this case second collum) and forth parametars is needed correct value or less then added (in this case correct value from those parametars 0),for asked first ranked classes from all classes formula is:
=VLOOKUP(1;I3:J17;2;0)

for second ranked clesses
=VLOOKUP(2;I3:J17;2;0)

for third ranked class is:
=VLOOKUP(3;I3:J17;2;0)

0djeljenje 1. clan 2. clan 3. clan 4. clan 5. clan ukupno boova
1-1 12 14 13 15 16 70
1-2 19 20 18 17 17 91
1-3 20 18 10 19 20 87
1-4 20 22 21 20 23 106
1-5 15 17 16 14 18 80
2-1 18 20 19 21 21 99
2-2 16 18 17 19 18 88
2-3 17 18 16 19 17 87
2-4 19 20 21 19 22 101
2-5 24 22 23 21 18 108
3-1 22 22 20 20 21 105
3-2 21 18 20 19 21 99
3-3 20 16 20 19 18 93
3-4 17 18 16 17 20 88
3-5 24 20 22 21 22 109

Picture 1.Class score

Picture 2. three first ranked classes

 

VLOOKUP - Classes -three firstplace classes from all classes,procedure:

  1. (vidi prethodne animaciis)
  2. choose cell for grade (D20).
  3. formula.
  4. mark formula =VLOOKUP(1;I3:J17;2;0).
  5. copy formulaCTRL+C
    6. .
  6. button(at end of the forula.
  7. choose cell D21 i vratiti PASTE kopiranu fomurlu CTRL+V .
  8. button(at end of the forula.
  9. choose cell D22 i vratiti PASTE kopiranu fomurlu CTRL+V .
  10. button(at end of the forula.
  11. choose cell D21 double click and change value first paametar for second place =VLOOKUP(2;I3:J17;2;0).
  12. button(at end of the forula.
  13. choose cell D22 double click and change value first parametar in 3 for third place =VLOOKUP(3;I3:J17;2;0).
  14. button(at end of the forula.
  15. End.

 Index