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

[µo°Ý] ·í¥X²{¼Æ¦rªºÄæ¦ì¤£¤@©w®É,¦p¦ó¥Î¤@­P©Ê¤½¦¡¨Dµª®×?

=OFFSET(A2,0,IF(A2<>"",1,MIN(IF(D2:H2<>"",COLUMN(D2:H2),9^9)))-1,1,1)-B2-H2
¼Æ²Õ¤½¦¡

TOP

        ÀR«ä¦Û¦b : ª¾ÃÑ­n¥Î¤ßÅé·|¡A¤~¯àÅܦ¨¦Û¤vªº´¼¼z¡C
ªð¦^¦Cªí ¤W¤@¥DÃD