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

¬D¿ï¤é´Á

¬D¿ï¤é´Á

A1-A31Äæ¬O¤é´Á1-31
B1-B31Äæ¬O­û¤u¤W¯Z¤é¡A¦ý¤£¬O¨C¤Ñ¤W¯Z
¨Ò¡G1-5¤é¤W¯Z 8-20¤W¯Z 27¤W¯Z

¦b
B40-B51¤ÎC40-c51
¨Ì§Ç¶ñº¡¤W¯Zªº¤é´Á
(¤W¯Z¤é´Á¤£·|¶W¹L22¤Ñ©Ò¥H®æ¤l°÷¥Î)

¥Øªº¬O­nª¾¹DXXX³o­Ó¤H¤W¯Z¤é¤l¦³¨º¨Ç

abc.rar (1.94 KB)

­ì¨Ó¬O³o¼Ë¡A¦A¦¸ÁÂÁ ANGELA ¤j­ôªº«ü¾É

TOP

B8­ì·N¬O"¤W¯Z"
B8§ïªÅ¥Õ,¨º·íµM¤£¯à¥Î¤F.
COUNTIF($B$8:$B$38,$B$8)
=> COUNTIF($B$8:$B$38,"¤W¯Z")

TOP

¥Î¤F ANGELA ¤j­ôªº¤èªk«áµo²{¤F¤@­Ó°ÝÃD´N¬O¨C¤ë²Ä¤@¤Ñ (B8)¨º¤@®æ­Y¬OªÅ¥Õªº¸Ü´NµLªk­pºâ¤F
«ç»ò·|³o¼Ë©O

TOP

¥u­n¦b¥»½×¾Â¦h¬Ý¦h°µ¦h°Ý,¤@¤Á·d©w.
¤£­n¤ß«æ.

TOP

·PÁ ANGELA ¤j­ôªº«ü¾É¡A¤]·PÁª©¥D¤§«eªºÀ°¦£¡A¦³ªÅ¯uªº­n¦n¦n¾Ç¤@¤U
¤£¹L¯x°}ÁÙ¯u¤£¤Ó¦nÀ´¡A¤£ª¾¦³¨S¦³¤°»ò¦n®Ñ¥i¬Ý¡A¤£¹L³o­Óºô¯¸¯u¬O­È±o±ÀÂ˪º¦nºô¯¸

TOP

COUNTA ¬O¥u­n¦³¸ê®Æ³£­pºâ,§ï¥Î
IF(12*(COLUMN(A$8)-1)+ROW($A1)>COUNTIF($B$8:$B$38,$B$8)

TOP

²{¦b¦³¹J¨ì ¤F¤@­Ó°ÝÃD´N¬O­ì¥»¨S¤W¯Zªº¦a¤è¬OªÅ¥Õªº¡A¥i¯à¦]¥ð°²¡A©Ò¥H´N¥´¤W¥ð°²
²{¦b¥X²{¤F#NUM!  
¦pªþ¥ó

·P®¦ª©¥D

abc.rar (2.88 KB)

TOP

·PÁª©¥D¡A­ì¨Ó¬O§Ú§âROW($A1)¤]§ï¦¨ROW($A8)©Ò¥H¤~¸ê®Æ¿ù»~¡AÁÂÁ¤F

TOP

B47
{=IF(12*(COLUMN(A$8)-1)+ROW($A1)>COUNTA($B$8:$B$38),"",SMALL(IF($B$8:$B$38="¤W¯Z",$A$8:$A$38,""),12*(COLUMN(A$8)-1)+ROW($A1)))}
ª¾¤§¬°ª¾¤§¡A¤£ª¾¬°¤£ª¾¡A¸Û¹ê¤]¡I

TOP

        ÀR«ä¦Û¦b : §Ú­Ì­n°µ¦nªÀ·|ªºÀô«O¡A¤]­n°µ¦n¤º¤ßªºÀô«O¡C
ªð¦^¦Cªí ¤W¤@¥DÃD