回答編集履歴
1
COUNTIFからRANKに変更
test
CHANGED
|
@@ -10,11 +10,11 @@
|
|
|
10
10
|
|
|
11
11
|
|
|
12
12
|
|
|
13
|
-
P2=
|
|
13
|
+
P2：=RANK(I2,I$2:I$16,1)
|
|
14
14
|
|
|
15
15
|
:(略)
|
|
16
16
|
|
|
17
|
-
V16=
|
|
17
|
+
V16：=RANK(O16,O$2:O$16,1)
|
|
18
18
|
|
|
19
19
|
|
|
20
20
|
|