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

[µo°Ý] ³£§ä¤£¨ì¥Ø¼Ð­È®É¡A«hÀx¦s®æÅã¥ÜªÅ¥Õ

[µo°Ý] ³£§ä¤£¨ì¥Ø¼Ð­È®É¡A«hÀx¦s®æÅã¥ÜªÅ¥Õ

§ä¤£¨ì¥Ø¼Ð­ÈÅã¥ÜªÅ¥Õ.rar (20.99 KB)
Sheet1
C21¤½¦¡¦b$D$19:$AZ$19¦³§ä¨ì>3ªº­È¡A©Ò¥HC21=5¡AC22=4  ==>¥¿½T¡C

Sheet2
C21¤½¦¡(¦PSheet1)¦b$D$19:$AZ$19¨S¦³§ä¨ì>3ªº­È¡A©Ò¥HC21(§t)¥H¤UÀx¦s®æÀ³¸ÓÅã¥Ü""¡A
¦ý¥Ø«eÅã¥Üªº¬O3,2,1,0  ==>¤£¥¿½T¡C

·QÅýSheet1& Sheet2³£¯àÅã¥Ü¥X¥¿½Tªºµª®×¡C
½Ð°Ý: C21¤½¦¡À³¸Ó¦p¦ó­×§ï?
ÁÂÁÂ !

{=IFERROR(LARGE(IF((D$19:AZ$19>3)*(COUNTIF(C$20:C20,D$19:AZ$19)=0),D$19:AZ$19),ROW(A1)),"")
google"EXCEL°g"  blog  ©Îgoogleºô§}:https://hcm19522.blogspot.com/

TOP

¦^´_ 2# hcm19522
h¤j:
±z¤Ó¯«¤F~~~~~
´ú¸ÕOK
¨ü¯q¨}¦h¡A¸U¤À·PÁ±z

TOP

¥»©«³Ì«á¥Ñ ziv976688 ©ó 2020-12-1 10:47 ½s¿è

¦^´_ 2# hcm19522
¤½¦¡°ÝÃD.rar (44.19 KB)
h¤j:
¤£¦n·N«ä¡A¤£ª¾¬O¤£¬O§Ú¦b§ï¤½¦¡¸Ìªº¦ì§}®É¦³µ§»~¡A©Ò¥H¤½¦¡®M¶i¹ê»Ú¨Ï¥Îªºªí®æ¸Ì¡A²£¥Í¤@¨Ç©_©Çªº²{¶H¡C
§Ú¬O¥ý¦b"¤C¬F"¤u§@ªíªºAA4©MBB4±N¤½¦¡¿é¤J§¹¦¨¡AµM«á¤U©Ô¨ì²Ä13¦C¡A¤§«á¦A½Æ»s¶K¤W¨ä¾l7­Ó¤u§@ªíªºAA4©MBB4¡A
©_©Çªº¬O°ÝÃD³£µo¥Í¦b©_¼Æªº¤u§@ªí¡A¥BAA4©MBB4¤U©Ôªº¤½¦¡­È¡A³£¬O¯Ê²Ä2¤jªº¼Æ¦r¡A
§Ú¤@¦AÀ˵ø¤½¦¡³£¨S¦³µo²{°ÝÃD¡Aªp¥B¤½¦¡³£¬O¤@¦¸½Æ»s¶K¤W¡A¦³°ÝÃD¤]À³¸Ó³£¦³°ÝÃD¡A«ç»ò·|¶¡¹j¤u§@ªí²£¥ÍBug?

¥H¤W·Ð½Ð±z¸Ñ´b¡CÁÂÁ±z^^

TOP

¦^´_ 4# ziv976688


    ¤G­ÓROW(A1)§ï1
google"EXCEL°g"  blog  ©Îgoogleºô§}:https://hcm19522.blogspot.com/

TOP

¦^´_ 5# hcm19522
h¤j:
OK¤F!«D±`ÁÂÁ±z

TOP

        ÀR«ä¦Û¦b : §Ñ¥\¤£§Ñ¹L¡A§Ñ«è¤£§Ñ®¦¡C
ªð¦^¦Cªí ¤W¤@¥DÃD