ML089

1. D2=INDEX($B$8:$B$14,MOD(MATCH(1,FREQUENCY(0,ABS($C2-N(OFFSET($B$7,ROW($1:$7),(8-COLUMN($A:$G))*5-4)))),)-1,7)+1)
   
2. 
   
3. E2=INDEX($B$8:$B$14,MOD(MATCH(1,FREQUENCY(0,ABS($C2-N(OFFSET($B$7,ROW($1:$7),(8-COLUMN($A:$G))*5-4)))),)-1,7)+1)

½Æ»s¥N½X

¤@¯ë¤½¦¡¡A¤U©Ô

hcm19522

http://blog.xuite.net/hcm19522/twblog/351535118
¼Æ¦r¶Ã¼Æ²£¥Í ®æ¦¡¤£¤@¼Ë °Ñ¦Ò§Y¥i

mmokdtmj

¦^´_ 7# ­ã´£³¡ªL


ª©¥D ÁÂÁ±z,

¥Ø«e¥i¥H¥Î¤F,

¦ý¬OIOps¼Æ¾Ú¦³¥i¯à·|·|¨ì10¸U,

¬O§_¥i¥H¤£²z¤p¼ÆÂI¦Ó´£¨ÑIOpsªº§PÂ_©O?

Thanks.

­ã´£³¡ªL

¦^´_ 6# mmokdtmj

¢Ò¢³¡G
=--RIGHT(MIN(INT(ABS(N(OFFSET($B$7,ROW($1:$7),COLUMN($A:$G)*5-4))-$C4)*10^8)*100+IF(D$1="TC",{32,16,8,6,4,2,1},$B$8:$B$14)),2)

IOps¡@¥u¯à¦b¸U¦ì¼Æ¤Î¤p¼ÆÂI¢·¦ì¼Æ¥H¤º¦³®Ä¡I¡]¤p¼ÆÂI¤Ó¦h¦ì¼Æ¤£¦n³B²z¡^

mmokdtmj

¦^´_ 4# ­ã´£³¡ªL

ª©¥D, ©êºp¤S¦³¤@­Ó°ÝÃD,

³o°ÝÃD¥X¦b§Ú¥N¤J¨ä¥¦IOps¼Æ­È®É,

D4 ©ME4 ´N¥N¥X¿ùªºTC ©MQD¤F,

ªþ¥ó¬O§ó·sªº¼Æ­È,

¤£ª¾¦p¦ó§ó§ï, ^^"

¤U¸ü (41.39 KB)

2015-10-21 21:05

Help3-2.rar (10.02 KB)

¤U¸ü¦¸¼Æ: 7

2015-10-21 21:08

mmokdtmj

¦^´_ 4# ­ã´£³¡ªL

­ì¨Ó¦p¦¹, ÁÂÁ±z¤SÅý§Ú³oªì¾ÇªÌ¤S¦h¾Ç¨ì¤@¶µ¤F,

§Ú¦b¨Ó­×§ï®M¥Î¨ì§Ú­ì¥»ªºªí®æ, ÁÂÁ±z^^

­ã´£³¡ªL

¦^´_ 3# mmokdtmj


¡Õ°}¦C¤½¦¡¿é¤Jªk¡Ö¡@
¿é¤J©Î­×§ï¤½¦¡§¹¦¨«á¡A´å¼Ð¯d¦b¡e½s¿è¦C¡f¡A¥ý¤£­n«öEnter¡A
¦P®É«ö¦í¡eShift + Ctrl¡f¤£©ñ¡A¦A«ö¡eEnter¡f¡C

¥t¡A¢Ò¢³¤½¦¡»P¤W¤@®æ¤£¤@¼Ë¡I

mmokdtmj

¦^´_ 2# ­ã´£³¡ªL


ÁÂÁª©¥DÀ°¦£,

¦ý§Ú¨Ì·Ó±zªº¤èªkÁÙ¬O¨S¿ìªk¨Ï¥Î,

¤£ª¾¹D¬°¤°»ò >.<

ÁÂÁÂ^^"

¤U¸ü (43.16 KB)

2015-10-21 20:06

Help2.rar (9.84 KB)

¤U¸ü¦¸¼Æ: 6

2015-10-21 20:06

­ã´£³¡ªL

±N¢Ó¢±¡G¢Ó¢³ªº¡e¦X¨Ö¡f¨ú®ø¡A§¹¦¨¤½¦¡«á¦A¦X¨Ö¡]°}¦C¤½¦¡µLªk¦b¦X¨Ö®æ¨Ï¥Î¡^

¢Ò¢±¡D°}¦C¤½¦¡¡G¥k©Ô¤@®æ¡A¤U©Ô¤@¦C
=MAX((N(OFFSET($B$7,ROW($1:$7),COLUMN($A:$G)*5-4))=$C2)*IF(D$1="TC",{32,16,8,6,4,2,1},$B$8:$B$14))

¢Ò¢³¡D°}¦C¤½¦¡¡G¥k©Ô¤@®æ
=--RIGHT(MIN(INT(ABS(N(OFFSET($B$7,ROW($1:$7),COLUMN($A:$G)*5-4))-$C4)*10^12)*100+IF(D$1="TC",{32,16,8,6,4,2,1},$B$8:$B$14)),2)

¥u°w¹ïªþÀÉ¡A¤£°£¿ù¡ã¡ã