Pezani Dongosolo mu Mndandanda ndi Ntchito INDEX

01 a 02

Ntchito ExE INDEX - Fomu Yowonjezera

Ntchito ya EXEX Ntchito mwachidule

Kawirikawiri, ntchito INDEX ikhoza kugwiritsidwa ntchito kupeza ndi kubwezera mtengo wapadera kapena kupeza selo loyang'ana pa malo a mtengo umenewo mu tsamba.

Pali mitundu iwiri ya INDEX ntchito yomwe ilipo mu Excel: Fomu ya Fomu ndi Fomu ya Fomu.

Kusiyana kwakukulu pakati pa mitundu iwiri ya ntchitoyi ndi:

• Fomu ya Array imabweretsanso kufunika kwa deta yomwe ili pamsewu wa pamtundu wina ndi gawo la deta;
• Fomu yowonjezeretsa imabweretsanso selolo la selo la malo ophatikizana a ndime ndi mzere wina.

Ntchito ExE INDEX - Fomu Yowonjezera

Kawirikawiri gulu limakhala ngati gulu la maselo omwe ali pafupi ndi tsamba. Mu chithunzi pamwambapa, mndandanda ukhala umodzi wa maselo kuchokera ku A2 mpaka C4.

Mu chitsanzo ichi, mawonekedwe osiyanasiyana a INDEX ntchito yomwe ili mu selo C2 amabwezeretsa kufunika kwa deta - Widget - yomwe imapezeka pamtunda wa mzere 3 ndi ndime 2.

Ntchito INDEX (Fomu ya Array) Syntax ndi Arguments

Mawu omasulira a ntchito amatanthawuza momwe ntchitoyo ikuyendera ndipo imaphatikizapo dzina la ntchito, mabakiteriya, olekanitsa, ndi zifukwa .

Chidule cha INDEX ntchito ndi:

= INDEX (Mzere, Row_num, Column_num)

Zowonjezera - Mafotokozedwe a maselo a maselo osiyanasiyana kuti afufuzidwe ndi ntchito yazomwe mukufuna

Werengani_num (zosankha) - Nambala ya mzere mkati momwe mungabwererenso mtengo. Ngati ndemangayi yasiya, Column_namafunika.

Column_num (zosankha) - Mzere wa chiwerengero mndandanda womwe ungabweretse mtengo. Ngati ndemanga iyi yasiya, Row_num ikufunika.

• Kwa ma Row_num ndi Column_nthano zowonjezera , mwina mzere weniweni ndi mndandanda wa zikhomo kapena mafotokozedwe a selo kumalo a chidziwitsochi mu tsamba lolembera akhoza kulowa.

Ntchito ya INDEX (Fomu ya Array) Chitsanzo

Monga tanenera, chitsanzo mu chithunzi pamwambapa chimagwiritsa ntchito mawonekedwe a INDEX ntchito kubwezera Widget nthawi kuchokera mndandanda wazomwe.

Zomwe zili pansipa zikukhudza njira zomwe zimagwiritsidwa ntchito kulowa INDEX ntchito mu selo B8 la pepala.

Masitepewa amagwiritsira ntchito mafotokozedwe a selo pa Row_num ndi Column_nkhani zotsutsana, m'malo molowa manambala awa molunjika.

Kulowa ntchito INDEX

Zosankha zogwira ntchito ndi zifukwa zake zikuphatikizapo:

1. Kujambula ntchito yonse: = INDEX (A2: C4, B6, B7) mu selo B8
2. Kusankha ntchito ndi zifukwa zake pogwiritsa ntchito INDEX ntchito dialog box

Ngakhale kuti n'zotheka kulembetsa ntchito yonse mwachindunji, anthu ambiri amavutika kuti agwiritse ntchito bokosi la polojekiti kuti alowetsedwe.

Masitepe awa pansipa agwiritse ntchito bokosi la polojekiti kuti alowe muzokambirana.

Kutsegula Bokosi la Zokambirana

Popeza pali mitundu iwiri ya ntchito - aliyense ali ndi zifukwa zake zokha - fomu lirilonse limafuna kuti likhale losiyana.

Zotsatira zake, pali njira yowonjezera potsegula INDEX ntchito yolemba bokosi osati kukhala ndi ntchito zina zambiri za Excel. Gawo ili limaphatikizapo kutenga mawonekedwe a Mzere kapena Fomu ya Mafotokozedwe yotsutsana.

Pansi pali njira zomwe zimagwiritsidwa ntchito kulowa mu INDEX ntchito ndi zifukwa mu selo B8 pogwiritsa ntchito bokosi la bokosi.

1. Dinani pa selo B8 pa tsamba - pameneyi ntchitoyi idzapezeka
2. Dinani pa Fomu tab ya menyu yowonjezera
3. Sankhani Kutsegula ndi Kutchulidwa kuchokera ku riboni kuti mutsegule ntchito yolemba pansi
4. Dinani ku INDEX mu mndandanda kuti mubweretse Chotsani Chotsutsana cha bokosi - chomwe chimakulolani kusankha pakati pa mawonekedwe Atsitsi ndi Otchulidwa a ntchitoyo
5. Dinani pa mndandanda, mndandanda_momwe, mndandanda_sankhulidwe
6. Dinani ku OK kuti mutsegule ntchito INDEX - Fomu ya bokosi la mawonekedwe

Kulowa Maganizo a Ntchito

1. Mu bokosi la bokosi, dinani pa mndandanda
2. Onetsetsani maselo A2 ku C4 mu tsamba lokuthandizani kuti mulowe muzenera
3. Dinani pa Row_num mzere mu bokosi la dialog
4. Dinani pa selo B6 kuti mulowetse selolo mu bokosi la dialog
5. Dinani pa Column_mu mzere mu bokosi la bokosi
6. Dinani pa selo B7 kuti mulowetse selololo mu bokosi la dialog
7. Dinani OK kuti mutsirize ntchitoyi ndi kutseka bokosi la bokosi
8. Mawu akuti Gizmo amawoneka mu selo B8 chifukwa ndilo mawu mu selo akudutsa mzere wachitatu ndi gawo lachiwiri la zigawo zowonjezera
9. Mukasindikiza pa selo B8 ntchito yonse = INDEX (A2: C4, B6, B7) ikuwoneka mu barra ya fomu pamwamba pa tsamba

Mndandanda wa Ntchito Yoposera Malamulo

Zotsatira zolakwika zofanana zomwe zimagwirizanitsidwa ndi INDEX ntchito - Fomu yamazere ndi:

#VALUE! - Imachitika ngati mwina Row_num , Column_nkhani zotsutsana siziri nambala.

#REF! - Zimapezeka ngati:

• Mndandanda wa Row_nthano ndi wamkulu kuposa chiwerengero cha mizere muzithunzi zosankhidwa;
• Mtsutso_makani ndi wamkulu kuposa chiwerengero cha zipilala muzithunzi zosankhidwa.

Bokosi la Zokambirana

Ubwino wogwiritsira ntchito bokosi la polojekiti kuti mulowetse zidziwitso zokhudzana ndi ntchitoyi ndi:

1. Bukhuli limasamalira mgwirizano wa ntchito - kuti zikhale zosavuta kulowetsa ziganizo zomwe zimagwira ntchito imodzi pokha popanda kuika chizindikiro chofanana, mabakiteriya, kapena makasitomala omwe amachititsa kuti azikhala osiyana pakati pazitsutsano.
2. Maumboni a magulu, monga B6 kapena B7, angathe kulowa mu bokosilo pogwiritsa ntchito kuwonetsa , zomwe zimaphatikizapo kusindikiza maselo osankhidwa ndi mbewa kusiyana ndi kuzilemba. Sikuti kumangosonyeza zosavuta, kumathandizanso kuchepetsa zolakwika m'mafomu omwe amachitidwa ndi Zolemba zosalunjika za selo.

02 a 02

Ntchito Exse INDEX - Fomu Yoyenera

Ntchito Exse INDEX - Fomu Yoyenera

Fomu yowonjezera ya ntchitoyi imabweretsanso kuwerengera kwa selo yomwe ili pamsewu wozungulira wa mzere wina ndi deta ya deta.

Mndandanda wa zolembazo ukhoza kukhala ndi mizere yambiri yosakhala yoyandikana monga ikusonyezedwa mu chithunzi pamwambapa.

Ntchito ya INDEX (Fomu ya Fomu) Syntax ndi Arguments

Chigwirizano ndi zifukwa za INDEX ntchito mawonekedwe Otchulidwa ndi:

= INDEX (Fufuzani, Row_num, Column_num, Area_num)

Lembani - (zofunikira) mafotokozedwe a maselo a maselo osiyanasiyana kuti afufuzidwe ndi ntchito yazomwe mukufuna.

• ngati maulendo angapo, osayandikana nawo alowetsedwa pamtsutso uwu, mzerewu uyenera kuzunguliridwa ndi makina osiyana a mabotolo monga momwe amasonyezera mu INDEX fomu: = INDEX ((A1: A5, C1: E1, C4: D5), B7 , B8) yotengedwa kuchokera ku chithunzi pamwambapa

Lembani_num - nambala ya mzere mkati momwe mungabwererenso mtengo.

• Zosankha zokhazokha pazitsulo zowerengera za mzere umodzi
• zofunikira pazomwelo limodzi ndi mndandanda wambiri wazowonjezera

Column_num - chiwerengero cha mndandanda muzomwe mungabwererenso mtengo.

• zosankhidwa pazomwe zilipo mndandanda wazomwezi
• zofunikira pa mzere umodzi ndi mndandanda wa maulendo ambiri

Zindikirani: Zonse za Row_num ndi Column_zinthu zotsutsana, mwina mzere weniweni ndi nambala za pamphindi kapena mafotokozedwe a selo kumalo a chidziwitso mu tsamba lolembera akhoza kulowa.

Malo_num (zosankha) - ngati mtsutso wotsutsa uli ndi mizere yambiri yosakhala yoyandikana, mtsutso uwu umasankha maselo angati kuti abwerere deta kuchokera. Ngati simukusiya, ntchitoyo imagwiritsira ntchito mtundu woyamba womwe uli mu ndondomeko yowonjezera.

• Mtundu woyamba unalowa mu ndondomeko ya Kuwerengera yawerengeka 1;
• yachiwiri ndi 2;
• lachitatu ndi lachitatu, ndi zina zotero.

Funso la INDEX (Fomu ya Fomu) Chitsanzo

Chitsanzo mu chithunzi pamwambachi chimagwiritsa ntchito fomu yowonjezera ya INDEX ntchito kuti ibwerere mwezi wa July kuchokera kumalo 2 a ukali A1 mpaka E1.

Zomwe zili pansipa zikukhudza njira zomwe zimagwiritsidwa ntchito kulowa mu INDEX ntchito mu selo B10 pa tsamba.

Masitepewa amagwiritsira ntchito mafotokozedwe a maselo a Row_num, Column_num, ndi Area_num kukangana, m'malo molowa manambala awa molunjika.

Kulowa ntchito INDEX

Zosankha zogwira ntchito ndi zifukwa zake zikuphatikizapo:

1. Kujambula ntchito yonse: = INDEX ((A1: A5, C1: E1, C4: D5), B7, B8) mu selo B10
2. Kusankha ntchito ndi zifukwa zake pogwiritsa ntchito INDEX ntchito dialog box

Ngakhale kuti n'zotheka kulembetsa ntchito yonse mwachindunji, anthu ambiri amavutika kuti agwiritse ntchito bokosi la polojekiti kuti alowetsedwe.

Masitepe awa pansipa agwiritse ntchito bokosi la polojekiti kuti alowe muzokambirana.

Kutsegula Bokosi la Zokambirana

Popeza pali mitundu iwiri ya ntchito - aliyense ali ndi zifukwa zake zokha - fomu lirilonse limafuna kuti likhale losiyana.

Zotsatira zake, pali njira yowonjezera potsegula INDEX ntchito yolemba bokosi osati kukhala ndi ntchito zina zambiri za Excel. Gawo ili limaphatikizapo kutenga mawonekedwe a Mzere kapena Fomu ya Mafotokozedwe yotsutsana.

Pansi pali njira zomwe zimagwiritsidwa ntchito kulowa mu INDEX ntchito ndi zokambirana mu selo B10 pogwiritsa ntchito bokosi la bokosi.

1. Dinani pa selo B8 pa tsamba - pameneyi ntchitoyi idzapezeka
2. Dinani pa Fomu tab ya menyu yowonjezera
3. Sankhani Kutsegula ndi Kutchulidwa kuchokera ku riboni kuti mutsegule ntchito yolemba pansi
4. Dinani ku INDEX mu mndandanda kuti mubweretse Chotsani Chotsutsana cha bokosi - chomwe chimakulolani kusankha pakati pa mawonekedwe Atsitsi ndi Otchulidwa a ntchitoyo
5. Dinani pazokambirana , mzere, mndandanda_num, malo_num kusankha
6. Dinani ku OK kuti mutsegule ntchito INDEX - Fomu yofotokozera mawonekedwe

Kulowa Maganizo a Ntchito

1. Mu bokosi la bokosi, dinani pa Tsambali
2. Lowani mzere wozungulira pozungulira " ( " pamzerewu mu bokosi la dialog
3. Onetsetsani maselo A1 kuti A5 alowe pa tsambalo kuti mulowe muzitsulo pambuyo pakatsegula
4. Lembani comma kuti mukhale olekanitsa pakati pa mzere woyamba ndi wachiwiri
5. Onetsetsani maselo C1 mpaka E1 mu pepala la ntchito kuti mulowetse mndandanda pambuyo pa comma
6. Lembani kamphindi wachiwiri kuti mukhale olekanitsa pakati pa gawo lachiwiri ndi lachitatu
7. Onetsetsani maselo C4 mpaka D5 mu tsamba lolemba kuti mulowetse mndandanda pambuyo pa comma
8. Lowetsani mzere womaliza " ) " Pambuyo pachitatu chachitatu kuti mutsirize mtsutso Wotchulidwa
9. Dinani pa Row_num mzere mu bokosi la dialog
10. Dinani pa selo B7 kuti mulowetse selololo mu bokosi la dialog
11. Dinani pa Column_mu mzere mu bokosi la bokosi
12. Dinani pa selo B8 kuti mulowetse selololo mu bokosi la dialog
13. Dinani Kumalo_mzere mubox
14. Dinani pa selo B9 kuti mulowetse selololo mu bokosi la dialog
15. Dinani OK kuti mutsirize ntchitoyi ndi kutseka bokosi la bokosi
16. Mwezi wa July umapezeka mu selo B10 chifukwa mwezi uli mu selo ukulozera mzere woyamba ndi gawo lachiwiri lachigawo (chachigawo C1 mpaka 1)
17. Mukasindikiza pa selo B8 ntchito yonse = INDEX ((A1: A5, C1: E1, C4: D5), B7, B8) ikuwoneka pa bar lamuzula pamwamba pa tsamba

Mndandanda wa Ntchito Yoposera Malamulo

Zotsatira zolakwika zofanana zomwe zimagwirizanitsidwa ndi INDEX ntchito - Fomu Yoyenera ndi:

#VALUE! - Imachitika ngati mwina Row_num , Column_num, kapena Area_num kukangana si nambala.

#REF! - Zikuchitika ngati:

• Mndandanda wa Row_nthano ndi wamkulu kuposa chiwerengero cha mizere muzithunzi zosankhidwa;
• Mtsutso_makani ndi wamkulu kuposa chiwerengero cha zipilala muzithunzi zosankhidwa.
• Malowa_makangano ndi aakulu kuposa chiwerengero cha malo omwe asankhidwa.