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

½Ð¯q-Äæ¦C¸ê®ÆÂà´«

½Ð¯q-Äæ¦C¸ê®ÆÂà´«

Dear All

   ¦³°Ñ¦Ò¹L¤§«eµo¤åªÌªº¸Ñªk¡A¤£¹L®×¨Ò¤£¦P¯uªºµLªkª½±µ§Q¥Î
§Úªº°ÝÃD¦p¤U ¥i§_½Ð°ª¤â¸ÑªR



Practice-1004.rar (3.44 KB)

¦^´_ 1# whyloveabby

D10°}¦C¤½¦¡
=IF(ROW(A1)>COUNT($E$3:$J$5),"",INDIRECT("D"&SMALL(IF(ISNUMBER($E$3:$J$5),ROW($E$3:$J$5),""),ROW(A1))))
E10¤½¦¡=IF($D10="","",INDEX($E$3:$J$5,MATCH($D10,$D$3:$D$5,0),(COUNTIF($D$9:$D10,$D10)-1)*2+1))
F10¤½¦¡=IF($D10="","",INDEX($E$3:$J$5,MATCH($D10,$D$3:$D$5,0),(COUNTIF($D$9:$D10,$D10))*2))
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

q.gif

TOP

        ÀR«ä¦Û¦b : ¤@¥y·Å·xªº¸Ü¡A´N¹³©¹§O¤H¨­¤WÅx­»¤ô¡A¦Û¤v·|ªg¨ì¨â¤Tºw¡C
ªð¦^¦Cªí ¤W¤@¥DÃD