¥»©«³Ì«á¥Ñ ziv976688 ©ó 2020-12-19 00:35 ½s¿è
´ú¸ÕÀÉ.rar (141.04 KB)
»¡©ú¡J
±N¨ç¼Æª©½d¨ÒªºB65¨ç¼Æ¤½¦¡¡A¶K¨ìµ{¦¡¥DÀɪº¦C147¡A
¤£ª¾¦ó¬G?¦C147µ{¦¡½XµLªk°õ¦æ¡A·|§e²{¦p¹Ï¤ùªº°»¿ù(¨ä¾l¤½¦¡ªºµ{¦¡°õ¦æ³£¨S¦³°ÝÃD)¡C
¦C147
[B65].FormulaArray = "=IF(MAX((COUNTIF($B1:B1,""<>"")=COUNTIF(OFFSET($B1,,,,COLUMN($A:$AW)),""<>""))*(SMALL(IF($A3:$A60=""¤pp"",ROW(3:60)),COUNTIF($B1:B1,""<>""))=ROW(3:60))*$B3:$AX60)=N(OFFSET($A1,SMALL(IF($A3:$A60=""¤pp"",ROW(3:60)),COUNTIF($B1:B1,""<>""))-1,COLUMN(A1))),OFFSET($A1,SMALL(IF($A3:$A60=""¤pp"",ROW(3:60)),COUNTIF($B1:B1,""<>""))-1,COLUMN(A1)),"""")"
PS¡J¦C147µ{¦¡½X¥Ø«eÂIºñ¨S¦³°õ¦æ¡C
½Ð°Ý¡J
¦p¦ó¤~¯à¸Ñ¨M°õ ¦æ¤½¦¡µ{¦¡ªºBug°ÝÃD¡H
ÁÂÁ¡I
|