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

±q¦³­ÈªºÄæ¬Û¥[

±q¦³­ÈªºÄæ¬Û¥[

¦U¦ì¤j¤j¦n
§Ú·Q­n±qAªí®æ¤ñ¹ï¸ê®Æ
¨Ì¾ÚAªí®æªº¨C¦CÀH¾÷¥X²{ªºÀx¦s®æÄæ¦ì
¥Ñ¥ª¦Ü¥k±a¤J­È
³Â·Ð¤j¤j­ÌÀ°¦£
·P®¦
¤£¦n·N«ä
§Ú¤£·|¤W¶ÇÀÉ®×
Snipaste_1.png
Snipaste_2.png
Snipaste_3.png

±NEXCELÀ£ÁY, ¦A¥Î¤W¶Ç,
¦h¸Õ´X¦¸~~

TOP

ÀH·NºÛ "EXCEL°g"  blog  ©Îhttps://hcm19522.blogspot.com/ EXCEL¨ç¼Æ

TOP

´ú¸Õ.rar (8.39 KB) ¦^´_ 2# ­ã´£³¡ªL


    ¥[¤JÀ£ÁYÀɤF
ÁÂÁ­ã¤j

TOP

¦^´_ 3# hcm19522


ÁÂÁÂhcm19522¤j¤j
¦ý±a¤Jªº­È
ÅܨS¿ìªk¥[Á`¤F...
§Ú»Ý­n¥[Á`Äæ¦ì
¦³¨ä¥L¤èªk¶Ü?

TOP

¦^´_ 5# 52ee24

=IF(COUNTIF($A2:A2,">0"),A$13,"")
ÀH·NºÛ "EXCEL°g"  blog  ©Îhttps://hcm19522.blogspot.com/ EXCEL¨ç¼Æ

TOP

A16:
=IF(MAX($A2:A2),A$13,"")
¥k©Ô/¤U©Ô

TOP

¦^´_ 7# ­ã´£³¡ªL
ÁÂÁ­ã¤jÀ°¦£
¥i¥H¥Î¤F
·PÁÂ

TOP

¦^´_ 6# hcm19522

ÁÂÁÂhcm¤j
¥i¥H¥[Á`¤F
·PÁ§A

TOP

        ÀR«ä¦Û¦b : ¦³®É·í«äµL®É­W¡A¦n¤Ñ­n¿n«B¨Ó³¡C
ªð¦^¦Cªí ¤W¤@¥DÃD