¥»©«³Ì«á¥Ñ ziv976688 ©ó 2020-12-16 20:47 ½s¿è
INDIRECT.rar (8.88 KB)
=IF(MAX((COUNTIF(OFFSET($B$1,,,,COLUMN($A:$AW)),"<>")=COUNTIF($B$1:B$1,"<>"))*$B4:$AX4)=B4,B4,"")
·Q±N¤Wz°}¦C¤½¦¡¦³ÃC¦âªºÀx¦s®æ¦ì§}¥HINDIRECT¨ç¼Æ§@°Ñ·Ó¡A
¥H§Q¤½¦¡¯à¤@¦¡¤U©Ô¹F¨ì»Ý¨Dµ²ªG(¸Ô¦pB24:AX29ªºµª®×)¡C
EX¡JB16
=IF(MAX((COUNTIF(OFFSET($B$1,,,,COLUMN($A:$AW)),"<>")=COUNTIF($B$1:B$1,"<>"))*INDIRECT("B"&$A16&":AX"&$A16))=INDIRECT("B"&$A16),INDIRECT("B"&$A16),"")
¦ý¦]INDIRECT¨ç¼Æ¤£¯à§@°ÊºA°Ñ·Ó¡A©Ò¥H¤½¦¡¥k©Ô¶ñº¡µL®Ä¡C
½Ð°Ý¡J
B16ªº¤½¦¡À³¸Ó¦p¦ó×¥¿¬°©y¡H
ÁÂÁ¡I |