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

[µo°Ý] ¼Æ¦r¦U¨ú1

[µo°Ý] ¼Æ¦r¦U¨ú1

­«½Æ¨ú1.rar (2.01 KB)
A2=B2¡GF2¥H¤Uªº¼Æ¦r¦U¨ú1
¤U©Ô¶ñº¡¡C

½Ð±Ð¡GExcel 2003ªº¨ç¼Æ¤½¦¡¡H
ÁÂÁ¡I

A2=IF(MAX(A$1:A1)>=MAX($B$2:$F$26),"",SMALL($B$2:$F$26,COUNTIF($B$2:$F$26,"<="&N(A1))+1))
¤U©Ô¶ñº¡¡C
¦ý·íÀx¦s®æ¦³¦h­Ó¼Æ¦r¨Ã¥H","²Å¸¹°Ï¹j®É¡A¤£ª¾¹D¤½¦¡­n«ç»ò§ï^^"
©|½Ð¦U¦ì¤j¤j¤£§[«ü¾É!ÁÂÁÂ!

TOP

¼Æ¦r¤£¶W¹L2¦ì¼Æ¾ã¼Æ¶Ü?
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

¦^´_ 3# ML089

¬Oªº!·Ð½Ð«ü¾É¡CÁÂÁ±z!

TOP

¦^´_ 1# ziv976688

A2 °}¦C¤½¦¡¡A¦p¤U
=LOOKUP(99,IF({1;0},{0,""},{1,1}*SMALL((FREQUENCY(--(0&TRIM(MID(SUBSTITUTE(B$2:B$33&","&C$2:C$33&","&D$2:D$33&","&E$2:E$33&","&F$2:F$33&",,,,,",",","         "),{0,1,2,3,4}*9+1,9))),ROW($1:$99)-1)=0)*999+(ROW($1:$100)-1),ROW(A2))))
¥H¤TÁä¤è¦¡¿é¤J¤½¦¡(SHIT+CTRL+ENTER)

¤½¦¡­­¨î
¼Æ¦r1~99
B:F¨C¤@¦C¦X¨Ö¤§¼Æ¦r¦ê¼Æ¤]¤£¯à¤Ó¦h(3~5­Ó)¡A¦]¬°¦r¦ê¤À¹j¥u´¡¤J9­ÓªÅ®æ¡A¤]¥i¼W¥[´¡¤JªÅ®æ¨Ó´£°ª¦r¦ê¼Æ¡C
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

A2//°}¦C:
=TEXT(SMALL(IF(COUNTIF(B:F,TEXT(ROW($1:$39),"!*00!*")),ROW($1:$39),99),ROW(A1)),"[<99]00;")

¼Æ¦r­­1~39
§âa:fÄæ³]¦¨¤å¦r®æ¦¡, ¦A±N³æ¿Wªº¼Æ¦r­«·s¿é¤J¬°¨â¦ì¼Æ, ¦p:05,06

TOP

¥»©«³Ì«á¥Ñ ziv976688 ©ó 2021-7-10 13:21 ½s¿è

¦^´_ 5# ML089
´ú¸Õ1000´Á¡A³æÀx¦s®æ³Ì¦h¥u¨£¹L3­Ó¼Æ¦r¡A©Ò¥H3~5­Ó¨¬°÷¥Î¤F¡C
·PÁ±zªº«ü¾É©MÀ°¦£

TOP

¦^´_ 6# ­ã´£³¡ªL
¦h¾Ç²ß¨ì©î¸Ñ¦³°Ï¹j²Å¸¹ªº¼Æ¦r¤§¤½¦¡¡C
·PÁ±zªº«ü¾É©MÀ°¦£

TOP

¥»©«³Ì«á¥Ñ hcm19522 ©ó 2021-7-22 11:17 ½s¿è

https://blog.xuite.net/hcm19522/twblog/589903456
ÀH·NºÛ "EXCEL°g"  blog  ©Îhttps://hcm19522.blogspot.com/ EXCEL¨ç¼Æ

TOP

¥»©«³Ì«á¥Ñ ziv976688 ©ó 2021-7-10 14:53 ½s¿è

¦^´_ 9# hcm19522
§Ú¦V¤p«Ä(¦~»´¤H¥Îªºª©¥»¤ñ¸û·s)­É2007ª©´ú¸Õ¬Ý¬Ý¡C
·PÁ±zªº½ç±Ð©MÀ°¦£:D

TOP

        ÀR«ä¦Û¦b : ½_ÁJµ²±o¶V¹¡º¡¡A¶V·|©¹¤U««¡A¤@­Ó¤H¶V¦³¦¨´N¡A´N­n¶V¦³Á¾¨Rªº¯ÝÃÌ¡C
ªð¦^¦Cªí ¤W¤@¥DÃD