- ©«¤l
- 19
- ¥DÃD
- 12
- ºëµØ
- 0
- ¿n¤À
- 60
- ÂI¦W
- 0
- §@·~¨t²Î
- XP
- ³nÅ骩¥»
- Office 2007
- ¾\ŪÅv
- 20
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2011-9-27
- ³Ì«áµn¿ý
- 2017-12-21
|
¦^´_ 2# register313
¤£¦n·N«ä~§Ú·ÓµÛ±z¨º°Ñ¼ÆקïÁÙ¬O¦³ÂI°ÝÃD¡A©ó¬O§Úקï¤@¨Ç~¤£ª¾þÃä¥X¤F°ÝÃD ¬O§_¯à«üÂI°g¾÷¤@¤U¡C
·Qnªº¥\¯à¬O D11~D90 »P D121 ¤ñ¸û ¬Ý¬O§_¬Û¦P~¬Û¦Pªº¸Ü±o¨ì¸Ó¦æ¼ÆÈ¡A¤Ï¤§±o¨ì65535¡A¦]¬°¼ÆÈ¥u¦³¤@²Õ¤@¼Ë©Ò¥H·|¦³¤@ӳ̤pÈ
¦A¥ÎSMALL( IF(),1) §ä¥X³Ì¤pªº¦æ¡A¦b¨Ï¥ÎINDIRECT("C"&¦æ) ¨D±o¹ïÀ³ªº¡i¾Éµ{¡jCÄæ¦ì- =INDIRECT("C"&SMALL(IF($D$11:$D$90=$D$124,ROW($D$11:$D$90),"65535"),1))
½Æ»s¥N½X ¤£ª¾¹Dק令³o¼Ë¬°¦ó¤£¦æ¡A¤£ª¾¹DþÃä¥X°ÝÃD{:3_54:} |
|