Excel乮僄僋僙儖乯妛廗幒 HOME


僄僋僙儖摿暿 壖斣 3

拞媺丒摿暿曇僩僢僾傊乿

丂丂丂摿丂暿丂壖斣 3
丂丂僼僅乕儉 僐儞僩儘乕儖乮儕僗僩 儃僢僋僗丄僐儞儃 儃僢僋僗乯

僼僅乕儉 僐儞僩儘乕儖乮儕僗僩 儃僢僋僗丄僐儞儃 儃僢僋僗乯

儕僗僩 儃僢僋僗丄僐儞儃 儃僢僋僗

儕僗僩 儃僢僋僗僐儞儃 儃僢僋僗偼旕忢偵帡偰偄傑偡丅


巊偄曽偼傎傏摨偠偱偡丅僙儖忋偺堦棗僨乕僞傪儃僢僋僗傊昞帵偝偣丄慖戰偟偰擟堄偺僙儖傊擖椡偡傞偙偲偑偱偒傞傕偺偱偡丅
傑偨丄擖椡婯懃偺儕僗僩婡擻偵傕帡偰偄傑偡丅


嵍恾嵍懁偼丄儕僗僩 儃僢僋僗丅塃懁偼僐儞儃 儃僢僋僗偱偡丅
儕僗僩 儃僢僋僗偼丄忋壓偺仯仴偱僨乕僞傪昞帵偝偣慖戰偟傑偡丅僐儞儃 儃僢僋僗偼仴偱丄儕僗僩傪昞帵偝偣慖戰偟傑偡丅

乮夋憸丗Win XP仌Excel2000乯

婎杮揑側巊偄曽

乮1乯儕僗僩 儃僢僋僗

儚乕僋僔乕僩忋傊儃僢僋僗傪昤偒傑偡丅師偵昞帵偝偣偨偄僨乕僞偺堦棗傪僔乕僩忋傊嶌傝傑偡丅偨偲偊偽B2乣B13傑偱弴偠1寧丄2寧丄3寧乧乧12寧偲嶌傝傑偡丅儃僢僋僗傪塃僋儕僢僋偟乽僐儞僩儘乕儖偺彂幃愝掕乿偺僐儞僩儘乕儖偺僞僽傪奐偒傑偡乮壓恾嶲徠乯丅


擖椡斖埻乮I乯傊偼丄僔乕僩忋偺堦棗僨乕僞偺斖埻傪擖椡偟傑偡丅

儕儞僋偡傞僙儖乮C乯偼丄慖戰寢壥偑曉傞僙儖偱偡丅擟堄偺僙儖傪慖戰偟擖椡偟傑偡丅

慖戰偺庬椶偵偼丄3庬椶偁傝傑偡偑丄扨堦慖戰乮S乯傪慖傃傑偡丅巆傝偺2偮偼儅僋儘偱巊梡偡傞傕偺偱偡丅

乮夋憸丗Win XP仌Excel2000乯

偙傟偱丄儃僢僋僗偺愝掕偼OK偱偡丅僔乕僩忋偱儃僢僋僗偵昞帵偝傟偨僨乕僞傪慖戰偡傞偲丄儕儞僋愭乽B1乿傊
乽1񎎙乧乿偑慖戰偵崌傢偣昞帵偝傟傑偡丅

師偵偙偺悢抣偐傜娭悢傪巊偭偰丄巜掕僙儖傊慖戰偟偨僨乕僞偑曉偝傟傞傛偆偵偟傑偡丅C2傊僨乕僞傪曉偡偲偟偰丄埲壓偺傛偆偵専嶕/峴楍娭悢偺INDEX娭悢傪巊偄傑偡丅
=INDEX(A1:A10,B1)
傑偨偼丄HLOOKUP娭悢偱傕壜擻偱偡丅埲壓偺傛偆偵側傝傑偡丅
=HLOOKUP(B2,B2:B13,F7,0)
偙傟偱儕僗僩 儃僢僋僗撪偱慖戰偟偨傕偺偑丄C2僙儖傊斀塮偝傟傞傛偆偵側傝傑偡丅

乮2乯僐儞儃 儃僢僋僗

僐儞儃 儃僢僋僗偺愝掕偼丄儕僗僩 儃僢僋僗偺愝掕偲傎傏摨偠偱偡丅乽僐儞僩儘乕儖偺彂幃愝掕乿偺僐儞僩儘乕儖偺僞僽偺撪梕偑彮偟堎側傝傑偡乮壓恾嶲徠乯丅

擖椡斖埻乮I乯傊偼丄僔乕僩忋偺堦棗僨乕僞偺斖埻傪擖椡偟傑偡丅

儕儞僋偡傞僙儖乮C乯偵偼丄慖戰寢壥傪曉偟偨偄僙儖傪慖戰偟擖椡偟傑偡丅

僪儘僢僾僟僂儞 儕僗僩偺寘悢偲偼丄仴傪僋儕僢僋偟偰昞帵偝偣傞悢偺偙偲偱偡丅婯掕抣偼8偱偡丅8埲忋偺僨乕僞偱偼僗僋儘乕儖僶乕偑昞帵偝傟傑偡丅
曄峏偡傞応崌偼僉乕儃乕僪偐傜捈愙懪偪崬傒傑偡丅

乮夋憸丗Win XP仌Excel2000乯

偙傟偱丄儃僢僋僗偺愝掕偼OK偱偡丅
屻偺娭悢側偳偺愝掕偼忋婰偺儕僗僩 儃僢僋僗偲慡偔摨偠偱偡丅忋婰偺夝愢傪嶲徠偟偰偔偩偝偄丅

擖椡斖埻乮I乯偼丄僙儖嶲徠柤慜偺掕媊柤偱擖椡偡傞偙偲偑偱偒傑偡丅偨偩偟丄僔乕僩忋偺堦棗僨乕僞偼丄廲曽岦偵擖椡偝傟偨傕偺偱側偄偲擣幆偝傟側偄偺偱拲堄偟偰偔偩偝偄丅
擖椡斖埻乮I乯丄儕儞僋偡傞僙儖乮C乯偲傕偵丄悢幃偼擖椡偱偒傑偣傫丅

巊偄曽偺墳梡乮儃僢僋僗傪楢摦偝偣傞曽朄乯

忋婰偺婎杮揑側巊偄曽偼丄扨弮側棙梡朄偱偡丅幚柋偱偼擇偮偺儃僢僋僗傪楢摦偝偣偰巊偄偨偄偲偄偭偨丄彮偟暋嶨側棙梡朄偑昁梫側偙偲偑偁傝傑偡丅
偨偲偊偽丄5恖偺塩嬈扴摉幰偑偄偰丄偦傟偧傟偑扴摉抧堟傪帩偭偰偄傞偲偟傑偡丅堦偮栚偺儃僢僋僗偱塩嬈扴摉幰柤傪愗傝懼偊傞偲丄擇偮栚偱偼偙偺塩嬈扴摉幰柤偵楢摦偟偰丄扴摉嬫堟偑帺摦揑偵愗傝懼傢傞偲偄偭偨棙梡偱偡丅
偦偆偟偨棙梡偱傕愝抲偡傞偙偲偑偱偒傑偡丅壓恾偼偦偺椺偱偡丅


堦偮栚偺塩嬈扴摉幰柤偵楢摦偟偰丄擇偮栚偺扴摉嬫堟偑帺摦揑偵愗傝懼傢傞傛偆偵偟偰偄傑偡丅

乮夋憸丗Win XP仌Excel2000乯

偙偺椺偼丄儚乕僋僔乕僩娭悢側偳傪巊偭偰偄傑偡偑丄幚偼僐儞僩儘乕儖僞僽偺擖椡斖埻乮I乯丄儕儞僋偡傞僙儖乮C乯偲傕偵丄悢幃偑擖椡偱偒側偄偲偄偆惂栺偑偁傝傑偡丅懠偺偙偆偟偨擖椡榞偱偼丄悢幃偑棙梡偱偒傞偺偱偡偑丄僐儞僩儘乕儖僞僽偱偼丄乽=乿傪擖傟傞偲寈崘偑弌傑偡丅偟偐偟丄柤慜偺掕媊偼巊偆偙偲偑壜擻偱偡偟丄偙傟傪巊偊偽偙偺栤戣傕僋儕傾偱偒傑偡丅

埲壓偱僐儞儃 儃僢僋僗偱偺愝抲庤弴傪帵偟傑偡丅
塩嬈扴摉幰傪乽將嶳乿乽嵅乆栘乿乽惵桍乿乽媨墍乿乽戝奯乿偲偟丄偦傟偧傟偑扴摉嬫堟傪庴偗帩偭偰偄傞偲偟傑偡丅壓恾偺傛偆偵塩嬈扴摉幰偲扴摉嬫堟傪堦棗昞偵偟偨傕偺傪嶌傝傑偡丅


師偵丄柤慜偺掕媊偱扴摉幰暿偵扴摉嬫堟偵柤慜傪晅偗傑偡丅

乮夋憸丗Win XP仌Excel2000乯

C3丗C7偼乽將嶳乿丄D3丗D7偼乽嵅乆栘乿偲偟弴師乽戝奯乿傑偱柤慜傪晅偗傑偡乮柤慜偺掕媊偼摿暿 6嶲徠乯丅

僔乕僩偵僐儞儃 儃僢僋僗傪擇偮愝抲偟傑偡丅
堦偮栚偺僐儞僩儘乕儖僞僽傪奐偒擖椡斖埻乮I乯傊塩嬈扴摉幰柤偺斖埻乽$A$3:$A$7乿傪巜掕偟丄儕儞僋偡傞僙儖乮C乯傊乽$B$12乿偲巜掕偟傑偡丅
師偵丄儕儞僋偡傞僙儖乽B12乿偺抣乮悢帤乯偐傜丄乽B13乿傊扴摉幰柤偑昞帵偝傟傞傛偆偵偟傑偡丅壓婰偺傛偆偵INDEX娭悢傪乽B13乿傊擖椡偟傑偡丅
=INDEX(A3:A7,B12)
偙傟偱丄堦偮栚偺儃僢僋僗偱慖戰偟偨扴摉幰柤偑乽B13乿傊昞帵偝傟傑偡丅乮2偮壓偺恾傪嶲徠乯

師偵丄乽B13乿偵昞帵偝傟傞塩嬈扴摉幰柤偐傜丄奺扴摉嬫堟偑敾暿偱偒傞傛偆岺晇傪偟傑偡丅偙偙偑億僀儞僩偱偡丅柤慜偺掕媊傪棙梡偟傑偡丅


嵍恾偺傛偆偵INDIRECT娭悢偱=INDIRECT(Sheet1!$B$13)
偲偟丄偙傟偵柤慜傪晅偗傑偡丅椺偱偼
儕僗僩乿偲偟偰偄傑偡丅柤慜偼帺桼偵晅偗傞偙偲偑偱偒傑偡丅
柤慜偺掕媊傪巊偊偽丄偙偺傛偆偵悢幃偵柤慜傪晅偗傞偙偲偑偱偒傑偡丅

乮夋憸丗Win XP仌Excel2000乯

INDIRECT娭悢偼丄暥帤楍偐傜偦偺嶲徠愭傪曉偡娭悢側偺偱乽B13乿偺扴摉幰柤偐傜丄偁傜偐偠傔塩嬈扴摉幰柤偱掕媊偟偰偄傞扴摉嬫堟傪敾暿偱偒傞偲偄偆傢偗偱偡丅乮INDIRECT娭悢 仺 拞媺23 嶲徠乯

嵟屻偵丄擇偮栚偺僐儞儃 儃僢僋僗偺僐儞僩儘乕儖僞僽傪愝掕偟傑偡丅
擖椡斖埻乮I乯偵偼丄柤慜偺掕媊柤乽儕僗僩乿傪擖椡偟偰巜掕偟傑偡丅儕儞僋偡傞僙儖乮C乯偵偼乽$D$12乿偲擖椡偟丄儕儞僋愭傪巜掕偟傑偡丅
懕偄偰丄儕儞僋偡傞僙儖乽D12乿偺抣乮悢帤乯偐傜丄乽D13乿傊扴摉嬫堟偑昞帵偝傟傞傛偆偵偟傑偡丅

嵍恾偺傛偆偵偺傛偆偵INDEX娭悢傪乽D13乿傊擖椡偟傑偡丅
=INDEX(C3:G7,D12,B12)
C3丗G7偼丄扴摉嬫堟偺慡斖埻偱偡丅
乮2偮忋偺恾傪嶲徠乯

乮夋憸丗Win XP仌Excel2000乯

偙傟偱丄擇偮栚偺儃僢僋僗偱巜掕偟偨扴摉嬫堟偑乽D13乿傊昞帵偝傟傑偡丅偙傟偱姰惉偱偡丅

儕僗僩 儃僢僋僗偱傕僐儞儃 儃僢僋僗偱傕丄偙偺椺偺傛偆偵儚乕僋僔乕僩娭悢偲柤慜偺掕媊傪巊偊偽丄暋悢偺儃僢僋僗傪帺嵼偵楢実偝偣傞偙偲偑偱偒傑偡丅

仸 儕僗僩 儃僢僋僗僐儞儃 儃僢僋僗偲傕偵乽儕儞僋偡傞僙儖乿偵昞帵偝傟傞僨乕僞偼丄Delete僉乕偱徚嫀偡偙偲偑偱偒傑偡丅徚嫀偵傛偭偰慖戰偼夝彍偝傟傑偡丅

擖椡婯懃偺儕僗僩偱傕擇偮偺儕僗僩傪楢摦偝偣傞偙偲偑壜擻偱偡丅偡偱偵丄One Point曇偺偦偺懠No 3偱夝愢偟偰偄傑偡偺偱嶲徠偟偰偔偩偝偄丅

丂丂丂愭摢傊栠傞丂丂丂

拞媺丒摿暿曇僩僢僾傊乿

Excel乮僄僋僙儖乯妛廗幒 HOME


KENZO30丂撪梕偺柍抐揮嵹偼嬛巭偟偰偄傑偡