I2:I13 {=OFFSET(A$1,SMALL(IF(D$2:D$3>=COLUMN(A:I),{1;2},99),ROW(A1)),)&""
J2:J13=IF(I2="","",TEXT(EDATE(VLOOKUP(I2,A:G,5,)&"1日",COUNTIF(I$2:I2,I2)-1),"YYY年M月"))
K2:K13=IF(I2="","",IF(I1=I2,IF(I2=I3,VLOOKUP(I2,A:G,7,),VLOOKUP(I2,A:G,3,)-SUMIF(I$1:I1,I2,K$1:K1)),VLOOKUP(I2,A:G,6,)))
留言
張貼留言