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

[µo°Ý] match¨ç¼Æ³B²z­«½Æ¼Æ­È¡A¦p¦ó¶Ç¦^³Ì«á²Å¦Xªº¦C¡H

¦^´_ 1# Bodhidharma

=INDEX(MATCH(2,1/(A1:A9="A")),)

TOP

¦^´_ 15# lukychien
{=SMALL(IF((A1:A20=E9),ROW(A1:A20)),D9)}

TOP

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