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

½Ð°ÝLOOKUP¦³¶i¶¥ª©¶Ü?

G2

=LOOKUP(2,1/FIND({"¥®¨à¶é","°ê¤p","°ê¤¤","°ª¤¤","¾Ç°|","Å@®Õ","¤j¾Ç"},D2),{1,2,3,4,5,5,5})
300 ¦r¸`¥H¤º
¤£¤ä«ù¦Û©w¸q Discuz! ¥N½X

TOP

¤í¯Ê¦Ò¼{ªÅ¥Õ
¸É¤W

G2

=LOOKUP(,-FIND({"","¥®¨à¶é","°ê¤p","°ê¤¤","°ª¤¤","¾Ç°|","Å@®Õ","¤j¾Ç"},D2),{"",1,2,3,4,5,5,5})
300 ¦r¸`¥H¤º
¤£¤ä«ù¦Û©w¸q Discuz! ¥N½X

TOP

        ÀR«ä¦Û¦b : §ïÅܦۤv¬O¦Û±Ï¡A¼vÅT§O¤H¬O±Ï¤H¡C
ªð¦^¦Cªí ¤W¤@¥DÃD