ªð¦^¦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 (9.08 KB)

Snipaste_1.png

Snipaste_2.png (6.07 KB)

Snipaste_2.png

Snipaste_3.png (20.87 KB)

Snipaste_3.png

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

TOP

google"EXCEL°g"  blog  ©Îgoogleºô§}:https://hcm19522.blogspot.com/

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,"")
google"EXCEL°g"  blog  ©Îgoogleºô§}:https://hcm19522.blogspot.com/

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 : ®É®É¦n¤ß´N¬O®É®É¦n¤é¡C
ªð¦^¦Cªí ¤W¤@¥DÃD