- ©«¤l
- 678
- ¥DÃD
- 147
- ºëµØ
- 0
- ¿n¤À
- 799
- ÂI¦W
- 0
- §@·~¨t²Î
- win 8
- ³nÅ骩¥»
- MS 2003
- ¾\ŪÅv
- 50
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2016-2-9
- ³Ì«áµn¿ý
- 2022-1-20
|
¥»©«³Ì«á¥Ñ ziv976688 ©ó 2018-5-3 23:35 ½s¿è
¦³¦bª¾ÃÑ+§ä¨ì7¨ú2²Õ¦Xªí¦Cªº¨ç¼Æ¤½¦¡
¤G¬P
J2=IF(ROW()>22,"",INDEX(B:H,COUNTA(A:A),SUM((ROW()-1>={1,7,12,16,19,21})*1)))
K2=IF(ROW()>22,"",INDEX(B:H,COUNTA(A:A),ROW()-LOOKUP(ROW()-1,{1,7,12,16,19,21},{0,5,9,12,14,15})))
7¨ú3~6¤Wºô§ä¤F¦n¤[¡A³£¬O²Îp±Æ¦C²Õ¦XÁ`²Õ¼Æªº¼Æ¾ÇÃD©ÎCOMBIN¨ç¼Æ¡A§ä¤£¨ì²Õ¦Xªí¦Cªº¨ç¼Æ¤½¦¡^^"
·Ð½Ð¦U¦ì¤j¤j«ü¾É!ÁÂÁÂ! |
|