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

[µo°Ý] ²Î­p¶µ§t¦³¤å¦r

B5:B6 °Ï°ì°}¦C¤½¦¡¡A¼Æ¶q¥Ñ¤j¦Ü¤p±Æ¦C¡A(¤p¦Ü¤j Åý§A½m²ß)
=INDEX($A:$AE,{1;2},MOD(LARGE(TEXT($B2:$AE2,"0;;0;!0")*10^4+COLUMN($B:$AE),COLUMN(A1)),10^4))

1 ¥ý½Æ»s¤½¦¡
2 ¿ï¾Ü B5:B6 Àx¦s®æ
3 ½s¿è¦C¶K¤W¤½¦¡
4 ¹«¼Ð¦ì©ó½s¿è¦C¡A¥Î¤TÁä(CTRL+SHIFT+ENTER)¿é¤J¤½¦¡
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

¥»©«³Ì«á¥Ñ ML089 ©ó 2021-10-7 20:07 ½s¿è

¦^´_ 13# johnny1680

B5 °}¦C¤½¦¡ (¤TÁä¿é¤J)
=INDEX($A:$AE,ROW(A1),MOD(SMALL(TEXT($B$2:$AE$2,"0;;\9\E\5;\8\E\5")*10^4+COLUMN($B:$AE),COLUMN(A1)),10^4))&""
¥k©Ô¤U©Ô¡A¤å¦r®æ¦¡


±Æ¦C¶¶§Ç¡G¼Æ¶q ¥Ñ¤p¦Ü¤j¡A¸É³f¤¤¡AªÅ®æ¶µ¥Ø
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

¦^´_ 12# johnny1680

²{¦b§Ú·Q±NLARGE§ï¬°SMALL
°é¿ïB5:B6¡A¦b½s¿è¦C±NLARGE§ï¬°SMALL«á¡A¦P®É«ö3Áä¡A«o¶]¥X"§A¤£¯à¥u§ïÅÜ1­Ó°}¦Cªº¤@³¡¤À"ªºÄµ»y¡F
§Ú±N½s¿è¦C¤½¦¡²¾°£©Î±NÀÉ®×Ãö³¬³£¤£¦æ¡A¤£ª¾¹D«ç»ò¿ì?
µ¥µo§¹³o½g¤å½Z¡A§Ú±j¨îÃö¾÷¬Ý¬Ý^^"
   


¤W¦¸§Ñ°O¦^Âгo°ÝÃD
°Ï°ì°}¦C¤½¦¡­×¥¿½T¹ê«Ü³Â·Ð¡A­ì¥ý¬O³æ®æ°}¦C¤½¦¡¡A¤£¯àª½±µ®M¤W¥h­×§ï¡A»Ý¥ý§R°£Â¤½¦¡¡A¤~¯à­«·s¤W°Ï°ì°}¦C¤½¦¡¡C

°Ï°ì°}¦C¤½¦¡¥H¤j¶q¸`¬Ù­pºâ¸ê·½¡A¤j¶q¼Æ¾Ú®É¤~Åé·|¡C
¨Ò¦p 10¸Uµ§¸ê®Æ¨ú³Ì¤p«e10­Ó¡A
  SMALL(10¸Uµ§¸ê®Æ¡Arow(a10)) ¥k©Ô10®æ¡Aªí¥Ü³o10­Ó³£»Ý­n³B²z 10¸Uµ§¸ê®Æ±Æ§Ç°µ10¦¸
  SMALL(10¸Uµ§¸ê®Æ¡Arow(1:10)) ª½±µ®M¦b10®æ¡Aªí¥Ü³o10­Ó¥u­n³B²z 10¸Uµ§¸ê®Æ±Æ§Ç°µ1¦¸¡A¤@¦¸ª½±µ¨ú¥X«e10²Õ¸ê®Æ¡A°Z¤£¬O§Ö«Ü¦h¡C
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

        ÀR«ä¦Û¦b : ­×¦æ­nô½t­×¤ß¡AÂǨƽm¤ß¡AÀH³B¾i¤ß¡C
ªð¦^¦Cªí ¤W¤@¥DÃD