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

¤£¦P¤é´Á(CDEÄæ)¤Î¤£¦P¸¹½X(BÄæ)­n¦p¦ó½s¸¹(AÄæ)¤Î²Î­pª÷ÃB(GÄæ)

¤£¦P¤é´Á(CDEÄæ)¤Î¤£¦P¸¹½X(BÄæ)­n¦p¦ó½s¸¹(AÄæ)¤Î²Î­pª÷ÃB(GÄæ)

A4¶}©lªºÀx¦s®æ¡A½s¸¹­n¦p¦ó³]©w¡H¡H¡H
AÄæ½s¸¹ªº³W«h¬O¡G
¨ÌCDEÄæ¤ÎBÄæ¡A¤]´N¬O¤£¦P¤é´Á¤Î¤£¦Pªº¸¹½X½s¸¹
¤£¦Pªº¤é´Á±q·s½s¸¹(¥Ñ1¶}©l½s)¡A¨Ò¦p¡GA20

G4¶}©lªºÀx¦s®æ¡A­n¦p¦ó³]©w¡H¡H¡H
G4²Î­pªº­ì«h¬O¡G
¨ÌCDEÄæ¤ÎBÄæ¦Ó¥[Á`FÄæª÷ÃB

³øªí.zip (37.42 KB)

joyce

¦^´_ 1# leiru

A4 =IF(B4="","",IF((C4=C3)*(D4=D3)*(E4=E3),IF(B4=B3,"",LOOKUP(1,0/A$3:A3,A$3:A3)+1),1))
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

G4
=IF(A4="","",IF(A5="",SUM(OFFSET(F4,,,IFERROR(MATCH(,0/A5:A$999,),COUNTA(B4:B$999)))),F4))
¶·¨Ï¥Î°}¦C¿é¤J ¥ý«öCTRL+SHIFT¤£©ñ ¦A¦P®É«öENTER
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

ÁÂÁÂML089¤j®v...¤£¦n·N«ä,¦A½Ð±ÐJÄ檺¤é´Á­n¦p¦ó³]©w¹ï»ô,¤]´N¬O
105/  2/20
105/  2/22
105/10/10
105/  3/20
joyce

TOP

        ÀR«ä¦Û¦b : ¡i®É¶¡¦pÆp¥Û¡j®É¶¡¹ï¤@­Ó¦³´¼¼zªº¤H¦Ó¨¥¡A´N¦pÆp¥Û¯ë¬Ã¶Q¡F¦ý¹ï·M¤H¨Ó»¡¡A«o¹³¬O¤@§âªd¤g¡A¤@ÂI»ù­È¤]¨S¦³¡C
ªð¦^¦Cªí ¤W¤@¥DÃD