ªð¦^¦Cªí ¤W¤@¥DÃD µo©«

·Qª¾¹D³sÄò¦h¤Ö­Ó¹s....

·Qª¾¹D³sÄò¦h¤Ö­Ó¹s....

¦U¦ì¤j­ô¡B¤j©j­Ì¡A¤j®a¦n
ªþ¥óÀÉ ½Ð±Ð.rar (8.06 KB) ¬O¦U²£«~¨C¤Ñªº­q³fª¬ªp¡A¦³­q¬°"1"¡A¨S­q¬°"0"
§Ú·Qª¾¹D¦U²£«~¦Ü¤µ¤w³sÄò¦h¤Ö¤Ñ¨S³Q¤U­q
¤]´N¬O·Q½Ð±Ð¥Ñ³Ì«á¤@µ§¸ê®Æºâ°_¡A¼Æ­È¬O0ªºÀx¦s®æ³sÄò¦³¦h¤Ö­Ó¡A¤½¦¡¸Ó«ç»ò³]©O?
·PÁ¤j®a¹©¤O¬Û§U

A²£«~, ¨ä¥L¨Ì¦¸¤U©Ô
=COUNTA(2:2)-LOOKUP(1,0/(A2:GG2),COLUMN(A:GG))

¥t¦³«Øij
¨Ì¸ê®Æª¬ªp¡A«Øij§ï¦¨««ª½«¬

TOP

·PÁÂKCC¤jªº¦^ÂÐ
¨ü±Ð¡A¤Ó·PÁ¤F

TOP

¥t¥~·Q¦A½Ð±ÐKCC¤j
½Ð°ÝLOOKUP(1,0/(A2:GG2),COLUMN(A:GG))ªº·N«ä¬O§_¬O....
1. ©óA2~GG2§ä´M³Ì«á¤@µ§1ªº¦ì¸m¡A¦P®É¦^¶Ç¬O­þ­ÓÄæ¦ì?
2. 0/(A2:GG2) »P A2:GG2ªº®t²§?
¹ï¤£°_¡A§Úexcelªº°ò¥»¥\¤£¬O«Ü¤ã¹ê¡A½¤F®Ñ¤S§ä¤£¨ìµª®×
¦AÀµ½Ð½ç±Ð¡AÁÂÁÂ

TOP

¦^´_ 4# cshd130


1. 0/(A2:GG2) ¡A­è·Q¨ì¡A¨º¹ï¬A¸¹¥i¥H¤£¥Î¥[
2.lookup¨Ì¹w³]¬d¸ß±ø¥ó¡A·|²¤¹L¿ù»~­ÈµM«á¬d¤p©ó©Îµ¥©ó1¡A¬d¤£¨ì´N©w¦ì¨ì³Ì«á¤@­Ó 0/1 ¡A¦A¥h§ä¥X¹ïÀ³ªº­È (column(...))
3.³o­Ó´Nºâµy·L¶i¶¥ªºexcel®Ñ®£©È¤]¤£®e©ö§ä§a¡A¤@¯ë°Ïªº°ÝÃD¦h¬Ý¬Ý¡A±`·|§Q¥Î³oºØ¸Ñªk¡C

TOP

¦^´_ 5# KCC

KCC¤j­ô¡AÁÂÁ±z­@¤ß«üÂI»P¤À¨É¸Ñ¨M¤F§Ú§xÂZ¦h®É¥B¦Ê«ä¤£±o¨ä¸Ñ°ÝÃD
¯u¬O·P¿E¤£ºÉ

TOP

        ÀR«ä¦Û¦b : §ïÅܦۤv¬O¦Û±Ï¡A¼vÅT§O¤H¬O±Ï¤H¡C
ªð¦^¦Cªí ¤W¤@¥DÃD