- ©«¤l
- 976
- ¥DÃD
- 7
- ºëµØ
- 0
- ¿n¤À
- 1018
- ÂI¦W
- 0
- §@·~¨t²Î
- Win10
- ³nÅ骩¥»
- Office 2016
- ¾\ŪÅv
- 50
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2013-4-19
- ³Ì«áµn¿ý
- 2024-10-30
|
¦^´_ 1# q1a2z5
¥Ò«D°²¤éC3=IFERROR(INDEX(¤u§@ªí!$A:$A,SMALL(IF(((¤u§@ªí!$C$2:$C$34=$A$3)+(¤u§@ªí!$D$2:$D$34=$A$3))*((¤u§@ªí!$B$2:$B$34<>"¤»")*(¤u§@ªí!$B$2:$B$34<>"¤é")),ROW($C$2:$C$34),""),COLUMN(A1))),"")
¥Ò°²¤éC5=IFERROR(INDEX(¤u§@ªí!$A:$A,SMALL(IF(((¤u§@ªí!$C$2:$C$34=$A$3)+(¤u§@ªí!$D$2:$D$34=$A$3))*((¤u§@ªí!$B$2:$B$34="¤»")+(¤u§@ªí!$B$2:$B$34="¤é")),ROW($C$2:$C$34),""),COLUMN(A1))),"")
¥H¤W³£¬O°}¦C¤½¦¡¡A¬õ¦âªº½Ð¦Û¦æקאּ¤A(a6) |
|