[µo°Ý] ­°¾­§ï¤É¾­

ziv976688

¤U¸ü (10.61 KB)

2020-11-29 18:35

B2ªº¥Ñ¤p¦Ó¤jªº±Æ¦C¤½¦¡¡A­n§ï¬°¥Ñ¤j¦Ó¤pªº±Æ¦C¤½¦¡

½Ð°Ý: B4ªº¤½¦¡­n¦p¦ó½s¼g ?

­°¾­§ï¤É¾­.rar (2.6 KB)

¤U¸ü¦¸¼Æ: 4

2020-11-29 18:37

ziv976688

¤£¦n·N«ä¡A¼ÐÃD¼gÄA­Ë¤F^^"
¥¿½T¼ÐÃD¬O"¤É¾­§ï¬°­°¾­"

°ÝÃD¤w¸Ñ¨M¡CÁÂÁÂ!
B4
=IF(COUNTIF($A4:A4,MIN($B1:$Z1)),"",LARGE($B1:$Z1,COUNTIF($B1:$Z1,">="&A4)+1))

hcm19522

¥k©Ô=IFERROR(LARGE($B2Z2,COLUMN(A1)),"")

ziv976688

¦^´_ 3# hcm19522
h¤j:
~«¢~°½¦Y¨B
«D±`·PÁ±zªº½ç±Ð

hcm19522

¦^´_ 4# ziv976688


    B2¥k©Ô {=IFERROR(SMALL(IF(($B1:$Z1>0)*(COUNTIF($A2:A2,$B1:$Z1)=0),$B1:$Z1),1),"")

¥H²Ä 1¦æ¬°¼Æ¾Ú B4¥k©Ô {=IFERROR(LARGE(IF(($B1:$Z1>0)*(COUNTIF($A4:A4,$B1:$Z1)=0),$B1:$Z1),1),"")

¥H²Ä 2¦æ¬°¼Æ¾Ú B4¥k©Ô=IFERROR(LARGE(IF($B2:$Z2<>"",$B2:$Z2),COLUMN(A1)),"")

ziv976688

¦^´_ 5# hcm19522
h¤j:
´ú¸Õ¥þOK
ÁÂÁ±zªº­@¤ß«ü¾É~·P®¦

PS:¦]¬°±`±`©Ó»X±zªº¤£§[«ü¾É~­¿·P¿Ë¤Á~©Ò¥H¦b3¼ÓÄæ¶}¤F­Ó"°½¦Y¨B"ªº¤pª±¯º¡F½Ð±z¸U¤£­n¨£©Ç¡CÁÂÁ±z^^"