- ©«¤l
- 32
- ¥DÃD
- 9
- ºëµØ
- 0
- ¿n¤À
- 46
- ÂI¦W
- 0
- §@·~¨t²Î
- windows XP
- ³nÅ骩¥»
- office 2007
- ¾\ŪÅv
- 10
- ©Ê§O
- ¨k
- ¨Ó¦Û
- °ª¶¯
- µù¥U®É¶¡
- 2010-5-11
- ³Ì«áµn¿ý
- 2021-4-27
|
¦^´_ 2# ANGELA
ÁÂÁÂANGELA¤j¤jªº¦^µª
·Q½Ð±Ð¤@¤U
1.µ²ªGsheet¤ºc2Àx¦s®æ={=INDEX(¸ê®Æ®w!A:A,MIN(IF(¸ê®Æ®w!$G$2:$K$8=$A2&$B2,ROW($A$2:$A$8),11)))}
¤½¦¡¤º11¥Nªí¤°»ò§t·N¡A¦³ÂI¤£À´¡A¥i¥H¸ÑÄÀ¤@¤U¶Ü?
2.¦]¬°§Úªº¸ê®Æ®w¤Îµ²ªGsheet¦³¤W¤dµ§¸ê®Æ¡A¥i¯à¤£¤Ó¾A¥Î¨ç¼Æ¯x°}¤è¦¡¡A·|³y¦¨³B²z¸ê®Æ³t«×ÅܺC
¥i¯à§ï¥ÑVBA¤è¦¡³B²z¸û§´·í¡A¥t§ïpoµ{¦¡°Ï´M¨D¸Ñ¨M¤ñ¸û¾A·í¡A«D±`·PÁ±zªº¦^µª! |
|