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

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

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

¥¼©R¦W.png
2020-11-29 18:35

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

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

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

¥»©«³Ì«á¥Ñ ziv976688 ©ó 2020-11-30 10:09 ½s¿è

¤£¦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))

TOP

¥k©Ô=IFERROR(LARGE($B2Z2,COLUMN(A1)),"")
ÀH·NºÛ "EXCEL°g"  blog  ©Îhttps://hcm19522.blogspot.com/ EXCEL¨ç¼Æ

TOP

¥»©«³Ì«á¥Ñ ziv976688 ©ó 2020-11-30 10:46 ½s¿è

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

TOP

¦^´_ 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)),"")
ÀH·NºÛ "EXCEL°g"  blog  ©Îhttps://hcm19522.blogspot.com/ EXCEL¨ç¼Æ

TOP

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

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

TOP

        ÀR«ä¦Û¦b : ¤H¨ÆªºÁ}Ãø»PµZ¿i¡A´N¬O¤@ºØ¦ÒÅç¡C
ªð¦^¦Cªí ¤W¤@¥DÃD