[µo°Ý] Äæ¦ì¼Æ±Æ§ÇÅܤƪº¤½¦¡¬ã²ß-1

ziv976688

¤U¸ü (115.53 KB)

2020-12-15 16:30

Äæ¦ì¼Æ±Æ§ÇÅܤƪº¤½¦¡¬ã²ß-1.rar (2.92 KB)

¤U¸ü¦¸¼Æ: 7

2020-12-15 16:31

¤£¦n·N«ä¡AB13ªº¤½¦¡¤@ª½§ï¤£¦¨¡AÀµ½Ð¦U¦ì¤j¤j¤£§[«ü¾É

°ÝÃD¦p¤U~
¨ú"¦¸¼Æ"¦C(B4:AN4)5­Ó°Ï¬q(8Äæ*4+7Äæ*1=¦@39Äæ)ªº¨C­Ó°Ï¬q³Ì¤j¼Æ~
B6¤½¦¡
=IF((B4=MAX(OFFSET($B4,,INT((COLUMN()-2)/8)*8,,8))),B4,"")

½Ð°Ý¡J
·Q¨ú"¦¸¼Æ"¦C(B11:AN11)5­Ó°Ï¬q(7Äæ*1+8Äæ*4=¦@39Äæ)ªº¨C­Ó°Ï¬q³Ì¤j¼Æ~
B13ªº¤½¦¡­n«ç»ò½s§ï¡H
ÁÂÁÂ

ziv976688

¦^´_ 4# hcm19522
h¤j¤j¡J±z¦n¡I
«¢~±z³o­Ó¤½¦¡¤Ó¦n¥Î¤F:victory:
¥»¨ÓÁÙ¾á¤ß¦U°Ï¬qÄæ¦ì¼Æªº±Æ¦Cªk¦@¦³10¦hºØ¡A¤£ª¾­nµo°Ý¨ì¦ó¦~¦ó¤ë?
²{¦b¤@¦¡¸Ñ¨M~±z¯u¬O¯«¤H¯Åªº¼F®`¡C
ÁÂÁ±zªº¼ö¤ßÀ°¦£©M­@¤ßªº«ü¾É~·P®¦:lol
===================================================
¤£¦n·N«ä¡A¦A½Ð°Ý¡J
¨ú¦U°Ï¬q³Ì¤j¼Æ(¥B¦Û°ÊÁY±Æ)ªº¤½¦¡¡A
B6ªº¤½¦¡­n¦p¦ó½s¼g¡H
ÁÂÁ±z:D

¤U¸ü (104.86 KB)

2020-12-16 16:31

¨ú¦U°Ï¬q³Ì¤j¼Æ(ÁY±Æ)ªº¤½¦¡.rar (3.6 KB)

¤U¸ü¦¸¼Æ: 1

2020-12-16 16:31

hcm19522

B13{=IF(MAX((COUNTIF(OFFSET($B9,,,,COLUMN($A:$AM)),"<>")=COUNTIF($B9:B9,"<>"))*$B11:$AN11)=B11,B11,"")

ziv976688

¦^´_ 2# hcm19522

¤U¸ü (121.98 KB)

2020-12-16 00:04

h¤j:
ÁÂÁ±zªº¦^ÂР  
´ú¸Õµ²ªG~µª®×¤£¥¿½T¡F
²Ä13¦Cªº¥¿½Tµª®×À³¦p²Ä16¦C¡C
Àµ½Ð±z¦A­×¥¿¡CÁÂÁ±z

hcm19522

=OFFSET($B3,,COLUMN()-LOOKUP(1,0/($B$9:B$9<>""),COLUMN($B:B))+MATCH(LOOKUP("¼_",$B$9:B$9),$2:$2,)-2)