ªð¦^¦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 : ¡i®É¤é²öªÅ¹L¡j¤@­Ó¤H¦b¥@¶¡°µ¤F¦h¤Ö¨Æ¡A´Nµ¥©ó¹Ø©R¦³¦hªø¡C¦]¦¹¥²¶·»P®É¶¡Ävª§¡A¤Á²ö¨Ï®É¤éªÅ¹L¡C
ªð¦^¦Cªí ¤W¤@¥DÃD