countif ¨C¤@¦æªº³Ì¤pȲÎp¦¸¼Æ
- ©«¤l
- 34
- ¥DÃD
- 9
- ºëµØ
- 0
- ¿n¤À
- 66
- ÂI¦W
- 0
- §@·~¨t²Î
- WinXP
- ³nÅ骩¥»
- office 2007
- ¾\ŪÅv
- 20
- ©Ê§O
- ¨k
- ¨Ó¦Û
- Taiwan
- µù¥U®É¶¡
- 2015-6-23
- ³Ì«áµn¿ý
- 2019-11-14
|
countif ¨C¤@¦æªº³Ì¤pȲÎp¦¸¼Æ
½Ð°Ý¦U¦ì«e½ú
S0 S1 S2 S3 S4 S5 S6 S7
94.39 93.47 92.17 93.59 94.13 90.7 94.48 93.88
95.71 92.82 91.91 93.59 94.99 92.73 92.02 93.17
92.41 92.31 94.26 91.36 93.59 93.6 95.09 96.6
93.73 93.47 91.15 92.18 94.69 93.9 93.25 95.22
94.39 92.53 92.17 93.84 94.41 93 95.38 94.88
94.72 94.57 94.27 94.69 91.92 97.67 95.71 95.92
94.39 92.61 90.86 91.62 92.48 91.57 92.64 94.22
93.05 92.82 90.34 93.56 94.15 93.31 93.56 93.17
97.03 92.88 92.37 89.94 94.68 93.88 93.56 96.94
92.74 92.05 90.36 91.09 92.18 91.86 93.25 94.22
S0¦¸¼Æ: ¬°¨C¤@¦æ¬O³Ì¤p¾®Éªº¦¸¼Æ |
|
|
|
|
|
|
- ©«¤l
- 2839
- ¥DÃD
- 10
- ºëµØ
- 0
- ¿n¤À
- 2895
- ÂI¦W
- 0
- §@·~¨t²Î
- ¡e²¤¡f
- ³nÅ骩¥»
- ¡e²¤¡f
- ¾\ŪÅv
- 100
- ©Ê§O
- ¨k
- ¨Ó¦Û
- ¡e²¤¡f
- µù¥U®É¶¡
- 2013-5-13
- ³Ì«áµn¿ý
- 2024-12-22
|
=COUNTIF(½d³ò, MIN(½d³ò)) |
|
|
|
|
|
|
- ©«¤l
- 34
- ¥DÃD
- 9
- ºëµØ
- 0
- ¿n¤À
- 66
- ÂI¦W
- 0
- §@·~¨t²Î
- WinXP
- ³nÅ骩¥»
- office 2007
- ¾\ŪÅv
- 20
- ©Ê§O
- ¨k
- ¨Ó¦Û
- Taiwan
- µù¥U®É¶¡
- 2015-6-23
- ³Ì«áµn¿ý
- 2019-11-14
|
¦^´_ 2# ã´£³¡ªL
V1==COUNTIF(B3:B241, MIN(B3:I241)) , µLªk§ä¥X¨C¤@¾î¦Cªº³Ì¤pÈ, ±N¨ä¦¸¼Æ¥[Á`
0 0 0 1 0 1 0 1
0@SITE_YIELD 1@SITE_YIELD 2@SITE_YIELD 3@SITE_YIELD 4@SITE_YIELD 5@SITE_YIELD 6@SITE_YIELD 7@SITE_YIELD
94.39 93.47 92.17 93.59 94.13 90.7 94.48 93.88
95.71 92.82 91.91 93.59 94.99 92.73 92.02 93.17
92.41 92.31 94.26 91.36 93.59 93.6 95.09 96.6
93.73 93.47 91.15 92.18 94.69 93.9 93.25 95.22
94.39 92.53 92.17 93.84 94.41 93 95.38 94.88
94.72 94.57 94.27 94.69 91.92 97.67 95.71 95.92
94.39 92.61 90.86 91.62 92.48 91.57 92.64 94.22
93.05 92.82 90.34 93.56 94.15 93.31 93.56 93.17
97.03 92.88 92.37 89.94 94.68 93.88 93.56 96.94
92.74 92.05 90.36 91.09 92.18 91.86 93.25 94.22
93.73 91.38 90.08 90.81 93.04 90.41 93.25 93.49
92.41 90.63 91.41 91.92 94.15 94.77 93.25 94.9
94.39 94.02 92.19 93.87 93.85 93.9 92.92 96.6
97.36 92 91.67 91.92 94.15 94.19 93.56 95.92
96.04 92.61 92.71 93.04 94.15 95.63 96.32 96.94
93.4 94 91.64 91.64 93.87 94.19 92.64 94.56
96.04 92.31 90.1 94.99 92.48 93.9 94.79 94.22
95.71 92.59 89.32 94.15 93.04 92.71 92.02 95.24
97.02 94.32 95.57 93.87 93.87 92.44 97.24 94.22
97.03 92.29 89.58 93.87 94.12 93 94.17 95.24
96.37 92.61 90.63 94.43 93.59 93.9 94.79 93.88
95.05 93.7 90.34 91.36 95.26 93.6 92.64 93.54
95.05 91.76 91.41 94.68 93.85 92.13 94.48 95.24
95.38 94.59 93.23 93.87 93.85 91.57 96.31 96.94
96.37 94.59 96.61 95.26 95.82 95.93 94.79 96.26
94.39 94.29 94.53 95.53 94.99 93.31 96.01 95.92
92.05 93.73 93.49 94.43 84.08 95.93 94.79 94.22
94.72 92.57 93.49 93.31 78.55 90.96 97.24 94.22
96.7 94.3 92.97 93.87 89.14 94.19 93.23 93.54
96.37 95.45 91.15 95.82 94.71 94.19 92.64 94.22
95.71 91.43 92.69 94.97 92.74 95.04 92.33 97.62
94.72 93.97 93.99 95.54 95.82 94.48 94.48 95.92
95.71 92.31 92.19 95.53 88.02 94.19 95.71 95.24
96.04 94.57 91.91 93.04 91.92 94.77 93.25 95.24
94.39 94.87 93.98 95.54 89.97 90.7 93.87 95.92
95.36 92.86 93.49 94.71 90.78 92.44 92.94 93.2 |
-
-
AAA.zip
(18.64 KB)
|
|
|
|
|
|
- ©«¤l
- 2839
- ¥DÃD
- 10
- ºëµØ
- 0
- ¿n¤À
- 2895
- ÂI¦W
- 0
- §@·~¨t²Î
- ¡e²¤¡f
- ³nÅ骩¥»
- ¡e²¤¡f
- ¾\ŪÅv
- 100
- ©Ê§O
- ¨k
- ¨Ó¦Û
- ¡e²¤¡f
- µù¥U®É¶¡
- 2013-5-13
- ³Ì«áµn¿ý
- 2024-12-22
|
¦^´_ 3# dragonhsu
¦U³æÄæ³Ì¤pÈ, ¦b¦U³æÄ椤ªºÓ¼Æ¡G
=COUNTIF(B3:B241, MIN(B3:B241))
¦U³æÄæ³Ì¤pÈ, ¦b¥þ³¡°Ï°ì¤¤ªºÓ¼Æ¡G
=COUNTIF($B3:$I241, MIN(B3:B241))
¥þ³¡°Ï°ì¤¤³Ì¤pÈ¡A¦b¦U³æÄ椤ªºÓ¼Æ¡G
=COUNTIF(B3:B241, MIN($B3:$I241)) |
|
|
|
|
|
|
- ©«¤l
- 34
- ¥DÃD
- 9
- ºëµØ
- 0
- ¿n¤À
- 66
- ÂI¦W
- 0
- §@·~¨t²Î
- WinXP
- ³nÅ骩¥»
- office 2007
- ¾\ŪÅv
- 20
- ©Ê§O
- ¨k
- ¨Ó¦Û
- Taiwan
- µù¥U®É¶¡
- 2015-6-23
- ³Ì«áµn¿ý
- 2019-11-14
|
¦^´_ 4# ã´£³¡ªL
Sorry.
¥i¯à¬O§Ú¨S»¡²M·¡
1. ¾î¦Vªº¦æ¦C¤¤¤ñ¸û¬O³Ì¤pªº¨Ã±NÅã¥Ü¬õ¦â
2. ¦bB1~I1 ªºÄæ¦ì, ²Îp¦UÄæÁa¦Vªº¬õ¦â³Ì¤pȪº¦¸¼Æ
Á|¨Ò
B C D E F
1 2 1 0 0 1
=====================================
2 5 6 7 8 9
3 2 5 6 7 8
4 5 3 7 8 9
5 8 9 7 5 1 |
|
|
|
|
|
|
- ©«¤l
- 2839
- ¥DÃD
- 10
- ºëµØ
- 0
- ¿n¤À
- 2895
- ÂI¦W
- 0
- §@·~¨t²Î
- ¡e²¤¡f
- ³nÅ骩¥»
- ¡e²¤¡f
- ¾\ŪÅv
- 100
- ©Ê§O
- ¨k
- ¨Ó¦Û
- ¡e²¤¡f
- µù¥U®É¶¡
- 2013-5-13
- ³Ì«áµn¿ý
- 2024-12-22
|
¦^´_ 5# dragonhsu
=SUMPRODUCT(N(B3:B241=SUBTOTAL(5,OFFSET($B2:$I2,ROW(3:241)-2,)))) |
|
|
|
|
|
|
- ©«¤l
- 34
- ¥DÃD
- 9
- ºëµØ
- 0
- ¿n¤À
- 66
- ÂI¦W
- 0
- §@·~¨t²Î
- WinXP
- ³nÅ骩¥»
- office 2007
- ¾\ŪÅv
- 20
- ©Ê§O
- ¨k
- ¨Ó¦Û
- Taiwan
- µù¥U®É¶¡
- 2015-6-23
- ³Ì«áµn¿ý
- 2019-11-14
|
·PÁ«e½ú, ¥i¥H¸ÑÄÀ¤@¤U¤½¦¡¶Ü ? |
|
|
|
|
|
|
- ©«¤l
- 2025
- ¥DÃD
- 13
- ºëµØ
- 0
- ¿n¤À
- 2053
- ÂI¦W
- 0
- §@·~¨t²Î
- WIN7
- ³nÅ骩¥»
- Office2007
- ¾\ŪÅv
- 100
- ©Ê§O
- ¨k
- ¨Ó¦Û
- ¥x¥_¥«
- µù¥U®É¶¡
- 2011-3-2
- ³Ì«áµn¿ý
- 2024-3-14
|
¦^´_ 3# dragonhsu
»²§UÄæ
A3 =MIN(B3:I3)
¤U©Ô
B1 =SUMPRODUCT(N(B3:B241=$A3:$A241))
¥k©Ô |
|
{...} ªí¥Ü»Ýn¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡
|
|
|
|
|
- ©«¤l
- 206
- ¥DÃD
- 3
- ºëµØ
- 0
- ¿n¤À
- 218
- ÂI¦W
- 0
- §@·~¨t²Î
- WIN10
- ³nÅ骩¥»
- OFFICE 365
- ¾\ŪÅv
- 100
- ©Ê§O
- ¨k
- ¨Ó¦Û
- ¥xÆW¥x¥_
- µù¥U®É¶¡
- 2010-5-15
- ³Ì«áµn¿ý
- 2023-6-18
|
¦^´_ ã´£³¡ªL
Sorry.
¥i¯à¬O§Ú¨S»¡²M·¡
1. ¾î¦Vªº¦æ¦C¤¤¤ñ¸û¬O³Ì¤pªº¨Ã±NÅã¥Ü¬õ¦â
2. ¦bB1~I1 ªºÄæ ...
dragonhsu µoªí©ó 2016-9-26 11:56
²Îp¦UÄæÁa¦Vªº¬õ¦â³Ì¤pȪº¦¸¼Æ |
|
300 ¦r¸`¥H¤º
¤£¤ä«ù¦Û©w¸q Discuz! ¥N½X
|
|
|
|
|