¦p¦ó±N¤@¤£µ¥¤j¤pdata°Ï¶ô±Æ¦¨¤@¦æ
- ©«¤l
- 2025
- ¥DÃD
- 13
- ºëµØ
- 0
- ¿n¤À
- 2053
- ÂI¦W
- 0
- §@·~¨t²Î
- WIN7
- ³nÅ骩¥»
- Office2007
- ¾\ŪÅv
- 100
- ©Ê§O
- ¨k
- ¨Ó¦Û
- ¥x¥_¥«
- µù¥U®É¶¡
- 2011-3-2
- ³Ì«áµn¿ý
- 2024-3-14
|
¥»©«³Ì«á¥Ñ ML089 ©ó 2017-8-24 09:26 ½s¿è
¦^´_ 3# jysun1
F13 {=LOOKUP(SMALL(($B$1:$C$99="")*4^7+ROW($1:$99),ROW(A1)*3-2),ROW($1:$99)/ISNA(MATCH(TEXT($A$1:$A$99,"[=]9"),$G$1:$I$1,)),$A$1:$A$99&"")
°}¦C¤½¦¡¡A¤U©Ô
G13 {=INDIRECT(TEXT(SMALL((($A$1:$A$99<>G$1)+($B$1:$C$99="")>0)*(60001)+ROW($1:$99)*10+COLUMN($B$1:$C$99),ROW(A1)),"!R0C0"),)&""
°}¦C¤½¦¡¡A¥k©Ô¤U©Ô
$99 ªí¥Ü³Ì¤Ö¶·¨Ì·Ó§AªºÀx¦s®æ³Ì«á¦ì¸m + 1 ®æ
ROW(A1)*3-2 ªí¥Ü Para1¡BPara2¡BPara3 ¦³ 3¡Aµø»Ý¨D½Õ¾ã 3 ¤Î $G$1:$I$1¡C |
|
{...} ªí¥Ü»Ýn¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡
|
|
|
|
|