- ©«¤l
- 186
- ¥DÃD
- 6
- ºëµØ
- 0
- ¿n¤À
- 218
- ÂI¦W
- 0
- §@·~¨t²Î
- win7
- ³nÅ骩¥»
- office 2007
- ¾\ŪÅv
- 20
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2012-11-12
- ³Ì«áµn¿ý
- 2014-4-15
|
¦^´_ 12# ML089
¶â¡A¥Îmin¬OÓ¦n¤èªk¡I
¬O»¡§Ú³Ìªñ¤]¹J¨ìÃþ¦üªº°ÝÃD¡G
if(¤@ªø¦êºâ¦¡=0,"",¤@ªø¦êºâ¦¡)
©Î¬O
if((¤@ªø¦êºâ¦¡=0)+(¤@ªø¦êºâ¦¡>¥t¤@ªø¦êºâ¦¡),"",¤@ªø¦êºâ¦¡)
³oÓ°£¤F¥Î©w¸q¦WºÙ¥~¡A¦³¬Ù²¤ªº¼gªk¶Ü¡H
note:
¤@ªø¦êºâ¦¡¡GINDEX('1020514¥þ¦W¥U'!A:A,MATCH(ROUNDUP((ROW()-2)/31,0)*3-2,'1020514¥þ¦W¥U'!A:A,0)+MOD(ROW()-3,31))
¥t¤@ªø¦êºâ¦¡¡GROUNDUP((ROW()-2)/31,0)*3 |
|