- ©«¤l
- 36
- ¥DÃD
- 11
- ºëµØ
- 0
- ¿n¤À
- 63
- ÂI¦W
- 0
- §@·~¨t²Î
- XP
- ³nÅ骩¥»
- office2003
- ¾\ŪÅv
- 20
- µù¥U®É¶¡
- 2015-4-18
- ³Ì«áµn¿ý
- 2023-10-3
|
¦^´_ 7# tyrone123456
tyrone123456±z¤Ó¯«¤F¡ã¡ã¡ã¡ã
¦¨¥\¤FC¡ã¡ã¡ã¡ã^O^
¦ý¦]¬°§Ú¹ïOFFSET¨ç¼Æ¥Îªk¤£¬O«ÜÁA¸Ñ¡ã
¥i§_¤è«K»P¸ß°Ý
±z©Ò³]©wªº
=OFFSET($A$2,ROW(I2)-2,0,1,1)»P
=IF(OFFSET($A$2,ROW(I14)-2,0,1,1)>0,OFFSET($A$5,ROW(I14)-2,0,1,1),"")
¤º®e¬O¤°»ò·N«ä©O¡H
§Ú·Q»¡Y§ÚÁA¸Ñ¸Ì±ªº³]©w¡ã¥H«á¤]³\¥i¥H¦A§ó¬¡¥Î¤F¡ã¡ã¡ã
¯uªº¤ÓÁÂÁÂtyrone123456¤jªº¤j¤O¨ó§U¤F¡ã
2500µ§ªºªí®æ²×©ó¦n¤F¡ã¡ã¡ã¡ã¡ã |
|