¥»©«³Ì«á¥Ñ Jared ©ó 2014-5-22 13:51 ½s¿è
·Q½Ð°Ý¤j¤j
¤é«e§Æ±æ¯à°÷¸Ì¥ÎSUMPRODUCT ¨Ó²Îp¼Æ¶q
¦ý¬O¦]¬°Äæ¦ì¸Ì±¨S¸ê®Æ
«o¥X²{¤F¿ù»~
n«ç»ò¤~¯à°÷²Îp(¦p¹Ï)
¦]¬°npºâ¦U°Ï¾P°â³Ì¤jÈ
©Ò¥H§Q¥Î =IF(E12="","",LARGE(E12:H12,1))
¨Ó¨ú±o¼Æ¦r
¦ý¬O¹ï©óÁÙ¨S¦³¶ñ¤W¸ê®ÆªºÄæ¦ì
«o¥X²{¤F¿ù»~
¸Ó«ç»ò¼g¤~¯àÁקK±¼³oÓ¿ù»~©O?
Àµ½Ð°ª¤H¸Ñµª¡A·P¿E¤£ºÉ¡I |