ªð¦^¦Cªí ¤W¤@¥DÃD µo©«

[µo°Ý] Åã¥Ü«ü©wªº¼Æ¦r

[µo°Ý] Åã¥Ü«ü©wªº¼Æ¦r



½d¨ÒªþÀÉ :

Åã¥Ü«ü©wªº¼Æ¦r.rar (2.18 KB)

¦^´_ 1# papaya


    J2:R2°}¦C¤½¦¡
=IFERROR(LARGE(IF(ISERROR(MATCH(ROW($1:$10)-1,$B$2:$H$2,0)),ROW($1:$10)-1,""),COLUMN(A$1:$I1)),"")
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

¦^´_ 2# Hsieh

¸Û¦p»Ý¨D!ÁÂÁ±z!

TOP

¥»©«³Ì«á¥Ñ hcm19522 ©ó 2019-1-10 14:04 ½s¿è

https://blog.xuite.net/hcm19522/twblog/586244002
google"EXCEL°g"  blog  ©Îgoogleºô§}:https://hcm19522.blogspot.com/

TOP

J2 =IFERROR(10-MATCH(,COUNTIF($B2:I2,10-ROW($1:$10)),),"")
°}¦C¤½¦¡ SHIFT+CTRL+ENTER»ô«ö¿é¤J¤½¦¡
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

¦^´_ 4# hcm19522

¤G­Ó¤½¦¡ªºµª®×³£¥¿½T¡C
ÁÂÁ¤j¤jªº«ü±Ð!

TOP

¦^´_ 5# ML089

ª©¥Dªº¤½¦¡¸û²µu¡Aµª®×¥¿½T!
ÁÂÁ±zªº«ü±Ð!

TOP

        ÀR«ä¦Û¦b : ¤ß¤¤±`¦sµ½¸Ñ¡B¥]®e¡B·P«ä¡Bª¾¨¬¡B±¤ºÖ¡C
ªð¦^¦Cªí ¤W¤@¥DÃD