- ©«¤l
- 1387
- ¥DÃD
- 4
- ºëµØ
- 0
- ¿n¤À
- 1397
- ÂI¦W
- 0
- §@·~¨t²Î
- WIN
- ³nÅ骩¥»
- 2007
- ¾\ŪÅv
- 50
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2015-9-11
- ³Ì«áµn¿ý
- 2024-11-28
|
D2:D6{=INDEX(B:B,SMALL(IF((ROW(B$3:B$14)>MATCH(,0/FIND("©ïÀY",B$3:B$14),)+2)*(ROW(B$3:B$14)<MATCH(,0/FIND("µ²§À",B$3:B$14),)+2),ROW(B$3:B$14),4^8),ROW(A1)))&""
E2:E6{=IF(MATCH(" <©ïÀY>",B:B,)+ROW(A1)>=MATCH(" <µ²§À> ",B:B,),"",INDEX(B:B,MATCH(" <©ïÀY>",B:B,)+ROW(A1)))
F2:F6{=IF(MATCH(,0/FIND("©ïÀY",B$3:B$14),)+ROW(A1)>=MATCH(,0/FIND("µ²§À",B$3:B$14),),"",INDEX(B:B,MATCH(,0/FIND("©ïÀY",B$3:B$14),)+ROW(A1)+2)) |
-
-
5208.png
(22.69 KB)
|