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

DDE°ÊºA¸ê®Æ¦p¦ó©w®É¿z¿ï¡H

¥»©«³Ì«á¥Ñ c_c_lai ©ó 2015-11-29 08:04 ½s¿è

¦^´_ 10# corcovado886
¥H¤U½d¨Ò¥uºtºâ¨ì A ~ AZ¡A¦pªG¹ê°È­È¦³¶W¥X AZ ªÌ¡A
¨Ì¤U­±¨Ò¤l¦A©¹¤UÄ~Äòºtºâ ( IIf( ... , ... , ...  ) )¤U¥h¡G
  1. .Range(IIf(cts > 26, "A" & Chr(64 + cts - 26), Chr(64 + cts)) & 10)
½Æ»s¥N½X

TOP

¢Ï¢¶¡G=IF(COUNT(0/(A2>9)),COLUMN(A1),"--")¡@¥k©Ô¦Ü¢ä¢¶
¢Ð¢µ¡G=IF(COLUMN(A1)>COUNT($A7:$V7),"",INDEX($A1:$V1,SMALL($A7:$V7,COLUMN(A1))))¡@¥k©Ô

TOP

·PÁ±zªºµo©«¡AÀò¯q¨}¦h!!!

TOP

        ÀR«ä¦Û¦b : ¤Hªº¤ß¦a¬O¤@²¥¥Ð¡A¤g¦a¨S¦³¼½¤U¦nºØ¤l¡A¤]ªø¤£¥X¦nªºªG¹ê¡C -
ªð¦^¦Cªí ¤W¤@¥DÃD