ªð¦^¦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 : §g¤l¥ß«í§Ó¡A¤p¤H«í¥ß§Ó¡C
ªð¦^¦Cªí ¤W¤@¥DÃD