- ©«¤l
- 35
- ¥DÃD
- 8
- ºëµØ
- 0
- ¿n¤À
- 45
- ÂI¦W
- 0
- §@·~¨t²Î
- Win7
- ³nÅ骩¥»
- 2010
- ¾\ŪÅv
- 10
- µù¥U®É¶¡
- 2015-9-22
- ³Ì«áµn¿ý
- 2016-4-14
|
¦^´_ 2# hcm19522
H¤j¤j¡A¦pªG§Úªº»Ý¨D¬O «á¤T½X001¡B002 ³£Åã¥Ü²Ä2ÓÄæ¦ì¤£¥Î¥h§PÂ_¡A·|¤£·|¤ñ¸û¦n¼g...¡H
¦]¬°§Ú¬Ý¤£À´³oÓ½d¨Ò....U2:U14=OFFSET(A$1,MAX(IF((MOD(COLUMN(A$2:G$14),6)=1)*(A$2:G$14=S2),ROW(A$2:G$14)-1)),IF(--RIGHT(S2)=1,2,10))
§Úµy·L®M¥Î«áÁÙ¬OµLªkÅã¥Ü....>0<"
½Ð¤j¤jÀ°¦£~QQ |
|