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

[µo°Ý] ¿ï¨ú²Ä1¦W~²Ä10¦W(¥i­«½Æ)¤Î¨ä«ü©w¹ïÀ³­È¡C

{=INDEX(2:2,SMALL(IF($B12:$AX12=B13,COLUMN($B:$AX)),COUNTIF($B13:B13,B13)))
ÀH·NºÛ "EXCEL°g"  blog  ©Îhttps://hcm19522.blogspot.com/ EXCEL¨ç¼Æ

TOP

B13{=IFERROR(SMALL(IF($B12:$AX12<11,$B12:$AX12),COLUMN(A1)),"")
ÀH·NºÛ "EXCEL°g"  blog  ©Îhttps://hcm19522.blogspot.com/ EXCEL¨ç¼Æ

TOP

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