- ©«¤l
- 2831
- ¥DÃD
- 10
- ºëµØ
- 0
- ¿n¤À
- 2887
- ÂI¦W
- 0
- §@·~¨t²Î
- ¡e²¤¡f
- ³nÅ骩¥»
- ¡e²¤¡f
- ¾\ŪÅv
- 100
- ©Ê§O
- ¨k
- ¨Ó¦Û
- ¡e²¤¡f
- µù¥U®É¶¡
- 2013-5-13
- ³Ì«áµn¿ý
- 2024-11-4
|
¢Ï¢³¡G¤U©Ô
=IF(ROW(A1)>COUNT(OFFSET(Sheet2!A$1,1,MATCH(A$3,Sheet2!$1:$1,)-1,99,2)),"",SMALL(OFFSET(Sheet2!A$1,1,MATCH(A$3,Sheet2!$1:$1,)-1,99,2),ROW(A1)))
©Î¡G
=LOOKUP("z",IF({1,0},"",TEXT(SMALL(OFFSET(Sheet2!A$1,1,MATCH(A$3,Sheet2!$1:$1,)-1,99,2),ROW(A1)),"yyyy/mm/dd")))
ª`·N¡G¦¹¤½¦¡¨ú¥Xªº¤é´Á¬°¡e¤å¦r®æ¦¡¡f
OFFSET(Sheet2!A$1,1,MATCH(A$3,Sheet2!$1:$1,)-1,99,2))¡@¬O°²³]¤é´Á¸ê®Æ³Ì¦h¢¸¢¸¦C¡A¥i¦Û¦æ½Õ¾ã¡ã¡ã |
|