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

[µo°Ý] °Ó«~«ö¥ý¶i¥ý¥Xªk¡A½Ð°Ý¦p¦ó­pºâ·l¯q¤Î®w¦s¶q¡H

[µo°Ý] °Ó«~«ö¥ý¶i¥ý¥Xªk¡A½Ð°Ý¦p¦ó­pºâ·l¯q¤Î®w¦s¶q¡H

¥«³õªi°Ê¤jªº°Ó«~¡A½Ð°Ý¦p¦ó«ö¥ý¶i¥ý¥Xªk­pºâ·l¯q¤Î®w¦s¶q¡H
(¤u§@ªí¤º¤½¦¡¡A¤wÃö³¬¿ù»~Àˬd¤Î¨Ï¥Î³sÄò½d³òµ´¹ï¦ì§}»P¬Û¹ï¦ì§}¤§ÅܤÆ)

¦A¦¹¡A¥ýÁ¹L©Ò¦³¦^µªªº¤j¤j­Ì¡I¡I
¸ê®Æ¦pªþ¥[ÀÉ¡C Book1.rar (2.28 KB)

©w¸q¦WºÙ
¶i»ù=IF(Sheet1!$C2=Sheet1!$C$5,INDEX(Sheet1!$D:$D,SMALL(IF(Sheet1!$C$2:$C2=Sheet1!$C$3,ROW(Sheet1!$A$2:$A2),65536),COUNTIF(Sheet1!$C$2:$C2,Sheet1!$C$5))),"")
G2=IF(ROW()>2,IF(H1>H2,D2-¶i»ù,""),"")
H2=IF(ROW()>2,H1+IF(C2=$C$2,1,-1),IF(C2=$C$2,1,-1))
¼Æ¶q¤£µ¥©ó1®É¦¹¤½¦¡¤£¯à¥Î,­n¨D§Uvba

TOP

        ÀR«ä¦Û¦b : ¹D¼w¬O´£ª@¦Û§Úªº©ú¿O¡A¤£¸Ó¬O¨þ¥¸§O¤HªºÃ@¤l¡C
ªð¦^¦Cªí ¤W¤@¥DÃD