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

[µo°Ý] ¦Û°Ê¼W¥[¦C°ÝÃD

[µo°Ý] ¦Û°Ê¼W¥[¦C°ÝÃD

¸ò¾ÚA¦C©Ò¥Ü¼Æ­È¼W¥[¦C,¦pA1=1¼W¥[¤@¦C,A2=4¼W¥[4¦C
¦p¦¹Ãþ±À
excel~ ¾Ç¦n¥L§a

¸ò¾ÚA¦C©Ò¥Ü¼Æ­È¼W¥[¦C,¦pA1=1¼W¥[¤@¦C,A2=4¼W¥[4¦C
¦p¦¹Ãþ±À
kan109 µoªí©ó 2017-5-18 13:36



    »²§U¦C¡Blookup©Îindex+match
    ­Y­nµL»²§U¦C¥i§Q¥Î¦psum+offset¨ú¥N»²§U¦C

sample1.1.xlsx.zip (7.26 KB)

TOP

sample1.zip (6.14 KB)
excel~ ¾Ç¦n¥L§a

TOP

        ÀR«ä¦Û¦b : ºw¤ô¦¨ªe¡C²É¦Ì¦¨ÅÚ¡A¤Å»´¤vÆF¡A¤Å¥Hµ½¤p¦Ó¤£¬°¡C
ªð¦^¦Cªí ¤W¤@¥DÃD