¦p¦ópºâ¤j©ó¥§¡¥B¤£«ÂЪº¶µ¥ØӼơH
- ©«¤l
- 113
- ¥DÃD
- 31
- ºëµØ
- 0
- ¿n¤À
- 149
- ÂI¦W
- 0
- §@·~¨t²Î
- xp & vista
- ³nÅ骩¥»
- 2003 & 2007
- ¾\ŪÅv
- 20
- µù¥U®É¶¡
- 2010-12-29
- ³Ì«áµn¿ý
- 2020-5-22
|
¦p¦ópºâ¤j©ó¥§¡¥B¤£«ÂЪº¶µ¥ØӼơH
¦pªþ¥ó
§Ú·Qnpºâ¤j©ó B Ä楧¡ªº Product ¶µ¥ØÓ¼Æ
¦]¦P¤@Ó Product ¦³¤£¦Pªº value
©Ò¥H¥un B Äæ¤j©ó¥§¡¡@¤£ºÞ¦P¤@Ó Product ¦³¦h¤ÖªºÈ²Å¦X±ø¥ó
¥un·í°µ¤@Ó Product °µpºâ´N¦æ¡@¤]´N¬O¤£«ÂÐpºâ Product Ó¼Æ
½Ð°Ý³o¼Ë¤½¦¡n«ç»ò¼g¡H
ÁÂÁ¡ã
Test.zip (5.87 KB)
|
|
|
|
|
|
|
- ©«¤l
- 113
- ¥DÃD
- 31
- ºëµØ
- 0
- ¿n¤À
- 149
- ÂI¦W
- 0
- §@·~¨t²Î
- xp & vista
- ³nÅ骩¥»
- 2003 & 2007
- ¾\ŪÅv
- 20
- µù¥U®É¶¡
- 2010-12-29
- ³Ì«áµn¿ý
- 2020-5-22
|
¦^´_ 9# ML089
ÁÂÁ¡ã
§Ú¤F¸Ñ³oÓ¤½¦¡¼gªkªºÅÞ¿è¤F |
|
|
|
|
|
|
- ©«¤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
![½×¾ÂºaÅA¾±³¹ ½×¾ÂºaÅA¾±³¹](images/common/medal14.gif) ![½×¾ÂÃÙ§U¾±³¹ ½×¾ÂÃÙ§U¾±³¹](images/common/medal3.gif) ![¼ö¯P°Ñ»P¾±³¹ ¼ö¯P°Ñ»P¾±³¹](images/common/medal7.gif) ![2014°¨¦~¥þ¶Ô¼ú³¹ 2014°¨¦~¥þ¶Ô¼ú³¹](images/common/ma.gif) ![2015¦Ï¦~¥þ¶Ô¼ú³¹ 2015¦Ï¦~¥þ¶Ô¼ú³¹](images/common/yang.gif) ![2016µU¦~¥þ¶Ô¼ú³¹ 2016µU¦~¥þ¶Ô¼ú³¹](images/common/hou.gif)
|
¦^´_ 8# Genie
Match¶Ç¦^¨C¤@¶µªº²Ä¤@Ó¦ì¸m¡A³o¬O²Îp¤£«Âжµ¥Øªº§Þ¥©¤èªk¤§¤@¡A¦A¥ÎFrequency²Îp¨CÓ¶µ¥Ø(match¤v¸gÂà´«¦¨row¦ì¸m)¦³¦h¤ÖÓ¡A³o®Éªºrown»Pmatch¹ïÀ³¡C |
|
{...} ªí¥Ü»Ýn¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡
|
|
|
|
|
- ©«¤l
- 113
- ¥DÃD
- 31
- ºëµØ
- 0
- ¿n¤À
- 149
- ÂI¦W
- 0
- §@·~¨t²Î
- xp & vista
- ³nÅ骩¥»
- 2003 & 2007
- ¾\ŪÅv
- 20
- µù¥U®É¶¡
- 2010-12-29
- ³Ì«áµn¿ý
- 2020-5-22
|
¦^´_ 5# ML089
½Ð°Ý³o¸Ì "ROW" ªº¥Îªk¤]¬OÅý¥¦¦^¶Ç "MATCH" ¨ç¦¡¬Û¹ïÀ³ªºÈ¶Ü¡H |
|
|
|
|
|
|
- ©«¤l
- 113
- ¥DÃD
- 31
- ºëµØ
- 0
- ¿n¤À
- 149
- ÂI¦W
- 0
- §@·~¨t²Î
- xp & vista
- ³nÅ骩¥»
- 2003 & 2007
- ¾\ŪÅv
- 20
- µù¥U®É¶¡
- 2010-12-29
- ³Ì«áµn¿ý
- 2020-5-22
|
¦^´_ 4# zz5151353
¤£¦n·N«ä
¥t¤@Ó°ÝÃD¬O¬°¤°»ò»Ýn¥Î¨ì "ROW" ³oӨ禡©O¡H
¤£¯àª½±µ¥Î "MATCH" ¨ç¦¡§ä¥X²Å¦X±ø¥óªºÈ´N¦æ¶Ü¡H |
|
|
|
|
|
|
- ©«¤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
![½×¾ÂºaÅA¾±³¹ ½×¾ÂºaÅA¾±³¹](images/common/medal14.gif) ![½×¾ÂÃÙ§U¾±³¹ ½×¾ÂÃÙ§U¾±³¹](images/common/medal3.gif) ![¼ö¯P°Ñ»P¾±³¹ ¼ö¯P°Ñ»P¾±³¹](images/common/medal7.gif) ![2014°¨¦~¥þ¶Ô¼ú³¹ 2014°¨¦~¥þ¶Ô¼ú³¹](images/common/ma.gif) ![2015¦Ï¦~¥þ¶Ô¼ú³¹ 2015¦Ï¦~¥þ¶Ô¼ú³¹](images/common/yang.gif) ![2016µU¦~¥þ¶Ô¼ú³¹ 2016µU¦~¥þ¶Ô¼ú³¹](images/common/hou.gif)
|
¦^´_ 3# Genie
MATCH(A2:A377,A2:A377,) ¦^¶ÇªºÈ¥i¯à¬° 1~376¡A¥Î°}¦Cªí¥Ü¬°ROW(1:376)¡A¼g¦¨ ROW(2:377)-1 ¬OÅý½d³ò¼Æ¦r¬Û¦PÅý¨Ï¥ÎªÌ¤ñ¸û®e©öק綠¦¡¡C
§Ú²ßºD¥Î MATCH(A2:A377,A:A,)©ÎMATCH(A2:A377,A1:A377,) ¦^¶ÇªºÈ¥i¯à¬° 2~377, ¥Î°}¦Cªí¥Ü¬°ROW(2:377)¡A¦ý¹ï¨Ï¥ÎªÌק綠¦¡¤ñ¸û®e©ö±NA1:A377§ï¿ù |
|
{...} ªí¥Ü»Ýn¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡
|
|
|
|
|
- ©«¤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
![½×¾ÂºaÅA¾±³¹ ½×¾ÂºaÅA¾±³¹](images/common/medal14.gif) ![½×¾ÂÃÙ§U¾±³¹ ½×¾ÂÃÙ§U¾±³¹](images/common/medal3.gif) ![¼ö¯P°Ñ»P¾±³¹ ¼ö¯P°Ñ»P¾±³¹](images/common/medal7.gif) ![2014°¨¦~¥þ¶Ô¼ú³¹ 2014°¨¦~¥þ¶Ô¼ú³¹](images/common/ma.gif) ![2015¦Ï¦~¥þ¶Ô¼ú³¹ 2015¦Ï¦~¥þ¶Ô¼ú³¹](images/common/yang.gif) ![2016µU¦~¥þ¶Ô¼ú³¹ 2016µU¦~¥þ¶Ô¼ú³¹](images/common/hou.gif)
|
{=COUNT(0/FREQUENCY(IF(B2:B377>D4,MATCH(A2:A377,A:A,)),ROW(2:377)))} |
|
{...} ªí¥Ü»Ý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
|
¥»©«³Ì«á¥Ñ zz5151353 ©ó 2012-11-29 17:55 ½s¿è
¦æ¼Æªº·N«ä±q 1~376 . ¥i¥H¼g¦¨³o¼Ë ROW(1:376)
{=SUM((MATCH(A2:A377&(B2:B377>D4),A2:A377&(B2:B377>D4),)=ROW(1:376))*(B2:B377>D4))} |
|
|
|
|
|
|
- ©«¤l
- 113
- ¥DÃD
- 31
- ºëµØ
- 0
- ¿n¤À
- 149
- ÂI¦W
- 0
- §@·~¨t²Î
- xp & vista
- ³nÅ骩¥»
- 2003 & 2007
- ¾\ŪÅv
- 20
- µù¥U®É¶¡
- 2010-12-29
- ³Ì«áµn¿ý
- 2020-5-22
|
¦^´_ 2# zz5151353
½Ð°Ý¬°¤°»ò¤½¦¡¤¤¬°¤°»òn "=ROW(2:377)-1"
³o¸Ì§Ú¬Ý¤£¤ÓÀ´¡K¡K |
|
|
|
|
|
|
- ©«¤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
|
|
300 ¦r¸`¥H¤º
¤£¤ä«ù¦Û©w¸q Discuz! ¥N½X
|
|
|
|
|