writer
6,694
edits
Changes
Jump to navigation
Jump to search
Line 18:
Line 18: − 1. Number={20,7,5,17,32}+ − RANK(7,C1:C5,0)=4 − RANK(7,C1:C5,1)=2 − 2. Number={10,4,-1,0,15,24,45} − RANK(4,G1:G7,0)=5 − RANK(4,G1:G7,1)=3 − RANK(-1,G1:G7,0)=7 − 3. Number={4,-1,-47,-23,0,-18,1,-35} − RANK(0,H1:H8,0)=3 − RANK(0,H1:H8,1)=6 − RANK(-18,H1:H8,1)=4 Line 43:
Line 33: + + + + + + + + + + + + + +
→Examples
==Examples==
==Examples==
{| class="wikitable"
{| class="wikitable"
|+Spreadsheet
|+Spreadsheet
| 4 || -1 || -47 || -23 || 0 || -18 || 1 || -35
| 4 || -1 || -47 || -23 || 0 || -18 || 1 || -35
|}
|}
#RANK(7,A1:E1,0) = 4
#RANK(7,A1:E1,1) = 2
#RANK(4,A2:G2,0) = 5
#RANK(4,A2:G2,1) = 3
#RANK(-1,A2:G2,0) = 7
#RANK(0,A3:H3,0) = 3
#RANK(0,A3:H3,1) = 6
#RANK(-18,A3:H3,1) = 4
==See Also==
==References==