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

[µo°Ý] ¦Ò¶Ôªí¤º³Ì¦h³s¤W¦h¤Ö¤é¯Z?

[µo°Ý] ¦Ò¶Ôªí¤º³Ì¦h³s¤W¦h¤Ö¤é¯Z?

³Ì¦h³sµf¦h¤Ö¤éªþ¥ó temp.zip (6.32 KB) ³Ì¦h³s¤W¦h¤Ö¤é?

¦^´_ 1# ricky8751


AF2=MAX(FREQUENCY(COLUMN(A2:AE2),((A2:AE2)<>"A")*COLUMN(A2:AE2)))-1
¤U©Ô

TOP

¦^´_ 2# samwang


    ÁÂÁ§AªºÀ°¦£~

TOP

        ÀR«ä¦Û¦b : ÁÀ¨¥¹³¤@¦·²±¶}ªºÂAªá¡A¥~ªí¬üÄR¡A¥Í©Rµu¼È¡C
ªð¦^¦Cªí ¤W¤@¥DÃD