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

[µo°Ý] INDIRECT¨ç¼Æ¤£¯à°ÊºA°Ñ·Óªº°ÝÃD

¨Ï¥ÎColumn + Char §t¼Æ·f°t¤£´N¥i¥H¤F?! CHAR(66)="B" ....??
·s¤â¤W¸ô¡A½Ð¦h¥]²[¡C

TOP

Here you are ~

=IF(MAX((COUNTIF(OFFSET($B$1,,,,COLUMN($AAW)),"<>")=COUNTIF($B$1:B$1,"<>"))*INDIRECT("B"&$A16&":AX"&$A16))=INDIRECT(CHAR(64+COLUMN(B16))&$A16),INDIRECT(CHAR(64+COLUMN(B16))&$A16),"")
·s¤â¤W¸ô¡A½Ð¦h¥]²[¡C

TOP

¦^´_ 9# ziv976688
Hello, ziv976688

¨Sª`·N¨ì§A¬O°}¦Cªº¤½¦¡, ­è¬Ý¤F¤@¤U, «e«á¤G­Ó¤½¦¡, ¦U¦Û¥Î³£¨S°ÝÃD, ¦ý¤@¬Û­¼´NFail,
©Î³\CountIFµLªk¨Ï¥Î©ó°}¦C§a?
­n¤£µM·Ç¤jÀ³¸Ó¤£·|¥ÎCountA¨Ó°µ.
³o¬O§Úªº²z¸Ñ.....Thanks ~

1. (COUNTIF(OFFSET($B$1,,,,COLUMN($A:$AW)),"<>")=COUNTIF($B$1:B$1,"<>"))
2. INDIRECT("B"&$A16&":AX"&$A16))
·s¤â¤W¸ô¡A½Ð¦h¥]²[¡C

TOP

        ÀR«ä¦Û¦b : «Ý¤H°h¤@¨B¡A·R¤H¼e¤@¤o¡A´N·|¬¡±o«Ü§Ö¼Ö¡C
ªð¦^¦Cªí ¤W¤@¥DÃD