Index index mu Excel

Chimodzi mwazinthu zofunikira kwambiri pa pulogalamu ya Excel ndi index ya wogwiritsa ntchito. Amasaka deta pamtundu wa mizere yomwe yatchulidwa ndi mzati, akubweza zotsatira mu khungu lokonzedweratu. Koma kuthekera kwa ntchitoyi kumawululidwa mukamagwiritsa ntchito njira zovuta kuphatikiza ndi ena ogwiritsa ntchito. Tiyeni tikambirane njira zosiyanasiyana zogwiritsira ntchito.

Kugwiritsa ntchito ntchito

Wogwiritsa ntchito index amatanthauza gulu la ntchito "zolumikizira" ndi arrays ". Ili ndi mitundu iwiri: ya Array ndi mafotokozedwe.

Njira ya Array ili ndi syntax:

= Index (mndandanda; nambala_Link; nambala_nmber)

Nthawi yomweyo, mikangano iwiri yomaliza yomwe ili munjirayi itha kugwiritsidwa ntchito, tonse pamodzi komanso aliyense wa iwo ngati mndandandawo ndiwofanana. Ndi mitundu yambiri, mfundo zonsezi ziyenera kugwiritsidwa ntchito. Ndikofunikiranso kuganizira za chiwerengero cha mzere ndipo mzerewo sunamvetsetse nambala pazogwirizana za pepalalo, koma dongosolo mkati mwa malo omwe atchulidwa.

Syntax ya kusankha kuwoneka motere:

= Index (ulalo; nambala_link; nambala_numbera; [Nambala_ dzina])

Apa mutha kugwiritsanso ntchito mkangano umodzi wokha kuchokera kuwiri: "mzere wa mzere" kapena "nambala". Kutsutsana "Nyuzi ya Dera" nthawi zambiri kumatha kusankha ndipo kumagwira pokhapokha ngati ma ranges angapo amatenga nawo ntchito.

Chifukwa chake, wothandizirayo akuyang'ana deta mu mtundu wa makonda pofotokoza chingwe kapena mzere. Izi ndizofanana kwambiri ndi kuthekera kwake. Mkono Wogwiritsa Ntchito Koma mosiyana ndi itha kusaka pafupifupi kulikonse, osati kokha m'mbali mwa tebulo.

Njira 1: Kugwiritsa ntchito Index ya Ogwiritsa ntchito kwa Arrays

Tiyeni tonsefe, choyamba, timapenda pa chitsanzo chosavuta cha algorithm pogwiritsa ntchito index ya orray.

Tili ndi tebulo la malipiro. Mu mzere wake woyamba, mayina a ogwira ntchito akuwonetsedwa, wachiwiri - tsiku lolipira, ndipo gawo lachitatu - kuchuluka kwa ndalama zomwe zimapeza. Tiyenera kuchotsa dzina la wogwira ntchitoyo mu mzere wachitatu.

Sankhani foni yomwe njira yokonza idzawonetsedwa. Dinani pa "ikani ntchito", yomwe ili nthawi yomweyo kumanzere kwa chingwe.

Sinthani ku mbuye wa ntchito mu Microsoft Excel

Njira yogwiritsira ntchito wizard yantchito imachitika. M'gulu la "zonena" ndi ma arrays "cha chida ichi kapena" mndandanda wathunthu wa zilembo "poyang'ana dzinalo". Atapeza kuti wothandizirayo, tikuutsimikizira ndikudina batani la "OK", lomwe limayikidwa pansi pazenera.

Windo laling'ono limatseguka, momwe muyenera kusankha mtundu wa mitundu: "Array" kapena "ulalo". Timafunikira kusankha "gulu". Ili koyamba ndipo ili yotsimikizika ndi zosasinthika. Chifukwa chake, titha kungodina batani la "OK".

Sankhani mtundu wa njira ya ntchito mu Microsoft Excel

NJIRA yotsutsa imatsegula cholembera. Monga tafotokozera pamwambapa, ili ndi zotsutsana zitatu, komanso minda itatu yodzaza.
Mu "gawo la" gawo la "Muyenera kufotokozera adilesi yazomwe zakonzedwa. Mutha kuyendetsa pamanja. Koma kuti athandizire ntchitoyo, tichita zina. Tinkaika chopirira ku gawo loyenera, kenako timakhala ndi deta yonse ya tabular pa pepalalo. Pambuyo pake, adilesi yamitundu imawoneka m'munda.
Mu "mzere nambala", timakhazikitsa nambala ya "3" 3 ", popeza, chifukwa, tifunika kutanthauzira dzina lachitatu pamndandanda. M'munda wa "Consem", khazikitsani nambala ya "1" 1, popeza kuti mzerewo ndiwo woyamba munthawi yodzipereka.

Pambuyo pa zoikamo zonse zomwe zanenedwa zimachitika, dinani batani la "OK".

Kukangana kwa Window Index ku Microsoft Excel

Zotsatira zakukonzanso zikuwonetsedwa mu khungu, zomwe zidafotokozedwa m'ndime yoyamba ya bukuli. Ndiwo dzina lomwe lili lachitatu pamndandanda womwe uli m'malo odzipereka.

Ntchito Zosintha Zakuthandizira mu Microsoft Excel

Tidasokoneza ntchito ya index igwira ntchito mu mitundu yambiri yamitundu (mizati ingapo). Ngati mtunduwo unali wofanana, ndiye kuti zodzaza ndi zenera pawindo sizingakhale zosavuta. M'munda "gulu" mwanjira yomweyo monga pamwambapa, timatchulapo adilesi yake. Pankhaniyi, mitundu yazomwe imapangidwa ndi mfundo zokhazokha mu "Dzinalo" chimodzi. Mu "mzere nambala", fotokozerani mtengo "3" 3, monga mukudziwira za mzere wachitatu. Gawo la "Consem 'mundawo limatha kusiyidwa kulibe kanthu, popeza tili ndi gawo limodzi lomwe gawo limodzi lokha limagwiritsidwa ntchito. Dinani pa batani la "OK".

Kukangana kwa Window Kuyika kwa gawo limodzi mu Microsoft Excel

Zotsatira zake zidzakhala chimodzimodzi monga pamwambapa.

Ntchito yokonzekera zotsatira za mtundu umodzi wa microsoft Excel

Inali chitsanzo chosavuta kwambiri, kotero kuti mukuwona momwe ntchitoyi imagwira ntchito, koma pochita, izi zimagwiritsidwa ntchito pano, sizimagwiritsidwa ntchito kawirikawiri.

Phunziro: Master of Nurctions

Njira 2: Kugwiritsa ntchito movutikira ndi wogwiritsa ntchito

Mukuchita, index ntchito nthawi zambiri imagwiritsidwa ntchito limodzi ndi mkangano. Mndandanda wa Bunch - Kampani yosaka ndi chida champhamvu mukamagwira ntchito bwino, zomwe zimasinthika molingana ndi ntchito yake kuposa analogue kwambiri - wogwiritsa ntchito.

Ntchito yayikulu ya ntchito yofufuzira ndikufotokozera nambala yomwe ili ndi phindu linalake.

Syntax wothandizira wa Syntax kwa izi:

= Kusaka Board (Kufunsa_kufuna, Kuwona_ [Ty_Denation])

Mtengo womwe mukufuna ndiye mtengo wake, mawonekedwe omwe muli osiyanasiyana;
Mndandanda womwe umawonedwa ndi mtundu womwe mtengo uwu umapezeka;
Mtundu wamapu ndi gawo losankha lomwe limatsimikiza ndendende kapena pafupifupi momwe mungayang'anire. Tionanso mfundo zolondola, kotero mkanganowu sugwiritsidwa ntchito.

Pogwiritsa ntchito chida ichi, mutha kuyambitsa mawu oyamba otsutsana "ndi nambala ya" nambala "ndi nambala" kuntchito.

Tiyeni tiwone momwe zingachitikire pa chitsanzo chapadera. Timagwira ntchito ndi tebulo lomwelo lomwe linakambidwa pamwambapa. Payokha, tili ndi minda iwiri yowonjezera - "dzina" ndi "kuchuluka". Ndikofunikira kupanga kuti dzina la wogwira ntchito liyambidwe, kuchuluka kwa ndalama zomwe zimapezeka zimangowonetsedwa zokha. Tiyeni tiwone momwe izi zitha kukhazikitsidwa muzoyeserera pogwiritsa ntchito index ntchito ndi kusaka.

Choyamba, tikuphunzirapo zomwe zimalandira malipiro antchito a Parfnov D. F. Lowani dzina lake ku gawo lolingana.

Dzinali limalembedwa m'munda mu Microsoft Excel

Sankhani cell mu "kuchuluka" komwe zotsatirazi zidzawonetsedwa. Yendani Window Window Index ya Arrays.
Mumunda "gulu" tikudziwitsa mgwirizano wa mzatiyo, momwe kuchuluka kwa malipiro ogwira ntchito kuli.
Munda wa "Column" wasiyidwa wopanda kanthu, monga momwe timagwiritsira ntchito chitsanzo chimodzi.
Koma mu gawo la "mzere", tidzafunikira kujambula ntchito yakusaka. Chifukwa cha mbiri yake, amatsatira syntax yomwe idafotokozedwa pamwambapa. Nthawi yomweyo m'munda ulowe dzina la wothandizira "kusaka" popanda mawu. Kenako tsegulani bulaketi ndikuwonetsa mgwirizano wa mtengo womwe mukufuna. Awa ndi magwiridwe antchito a selo yomwe tidalemba dzina la wogwira ntchito wa Parfenov payokha. Tidayika mfundo ndi comma ndikunena zogwirizana za mtundu womwewo. Kwa ife, ili ndi adilesi ya mzati ndi mayina a ogwira ntchito. Pambuyo pake, tsekani bulaketi.
Makhalidwe onse amapangidwa, dinani batani la "OK".

Zenera lotsutsana la index ya ntchito limodzi ndi ogwiritsa ntchito oyang'anira mu Microsoft Excel

Zotsatira za kuchuluka kwa zomwe zimapeza Parfenova D. F. Pambuyo pokonza zikuwonetsedwa mu "kuchuluka" m'munda.

Ntchito yokonzekera zotsatira zophatikizira ndi wogwiritsa ntchito makina ku Microsoft Excel

Tsopano, ngati mu "Dzinalo" tidzasintha zomwe zili pa Parfnov.

Kusintha kwamakhalidwe mukamagwiritsa ntchito njira yolumikizirana ndi wogwiritsa ntchito mu Microsoft Excel

Njira 3: Kukonza matebulo angapo

Tsopano tiyeni tiwone momwe index ingagwiritsidwe ntchito ndi matebulo angapo. Pazifukwa izi, chiwerengero chowonjezera "chidzagwiritsidwa ntchito.

Tili ndi matebulo atatu. Gome lililonse limawonetsa malipiro a ogwira ntchito pamwezi. Ntchito yathu ndikudziwa malipiro (mzere wachitatu) wa wogwira ntchito wachiwiri (mzere wachiwiri) kwa mwezi wachitatu (dera lachitatu).

Timasankha foni yomwe zotsatira zake ndi zotulutsa ndipo zimatha kutsegula ntchito ya Wizard, koma posankha mtundu, sankhani mawonekedwe. Timafunikira izi chifukwa ndi mtundu uwu womwe umathandizira kugwira ntchito ndi mfundo yotsutsana ".

Kusankha mtundu wa njira yantchito mu Microsoft Excel

Khomo lachikangano limatseguka. Mu gawo lolumikizana, tifunika kutchula ma adilesi onse atatu. Kuti muchite izi, khazikitsani cholozera m'munda ndikusankha gawo loyamba ndi batani lakumanzere. Kenako ikani mfundo ndi comma. Izi ndizofunikira kwambiri, chifukwa ngati mupita ku kumasulidwa kwa mndandanda wotsatirawo, ndiye kuti adilesi yake ingolowa m'malo mwazomwe zapita kale. Chifukwa chake, mutalowa mfundo ndi comma, timagawa zotsatirazi. Kenako ikani mfundo ndi comma ndikugawa malo omaliza. Mawu onse omwe ali mu gawo la "ulalo" amatenga mabakiketi.
Mu "mzere nambala", sonyezani nambala yakuti "2", pamene tikufuna mtundu wachiwiri pamndandanda.
M'munda wa "Consem 'mundawo, fotokozerani nambala ya" 3 ", popeza mtundu wa malipiro ndi gawo lachitatu mu akaunti pagome lililonse.
M'munda wa "dera la" Takhazikitsa nambala ya "3" 3 ", popeza tikufunika kupeza deta mu tebulo lachitatu, lomwe lili ndi zambiri zokhudzana ndi malipiro a mwezi wachitatu.
Pambuyo pazonse zomwe zalembedwa, dinani batani la "OK".

NJIRA YOPHUNZITSIRA YOPHUNZITSIRA MALO OGWIRA NTCHITO YOPHUNZITSIRA NDIPONSO ZINSINSI ZONSE MU Microsoft Excel

Pambuyo pake, zotsatira za kuwerengera zimawonetsedwa mu chipinda chosankhidwa. Pakuwonetsa kuchuluka kwa malipiro a wogwira ntchito wachiwiri (Safronova V. M. M.) kwa mwezi wachitatu.

Ntchito yokonzekera zotsatira za kugwira ntchito ndi madera atatu mu Microsoft Excel

Njira 4: Kuwerengera kuchuluka kwake

Fomu yotchulidwa siimagwiritsidwa ntchito monga momwe amagwirira ntchito monga mawonekedwe a mndandanda, koma sizingagwiritsidwe ntchito pokhapokha pogwira ntchito ndi magawo angapo, komanso zofuna zina. Mwachitsanzo, itha kugwiritsidwa ntchito kuwerengera ndalamazo kuphatikiza ndi ogwiritsa ntchito.

Mukawonjezera kuchuluka, syntax zotsatirazi ili ndi:

= Sums (adilesi_Malasiva)

M'malo mwathu, kuchuluka kwa ndalama zonse ogwira ntchito pamwezi kumawerengeredwa pogwiritsa ntchito njira zotsatirazi:

= Kuchuluka (C4: C9)

Zotsatira za ntchito ya kuchuluka kwa Microsoft Excel

Koma mutha kuzisintha pang'ono pogwiritsa ntchito cholembera. Kenako adzakhala ndi mawonekedwe awa:

= Sum (C4: Index (C4: C9; 6))

Zotsatira za kuphatikiza kwa ndalama za Sums ndi Index mu Microsoft Excel

Pankhaniyi, khungu limawonetsa mgwirizano wa mndandanda wa mndandandawo, womwe umayamba. Koma m'malo ogwiritsira ntchito njira ya mndandanda wa mndandandawo, wogwiritsa ntchito yemweyo amagwiritsidwa ntchito. Pankhaniyi, mkangano woyamba wa index wogwiritsa ntchito akuwonetsa kuchuluka kwake, ndipo chachiwiri - pa khungu lake lomaliza - wachisanu ndi chimodzi.

Phunziro: Zinthu Zothandiza Zapamwamba

Monga mukuwonera, ntchito ya Index imatha kugwiritsidwa ntchito pakukhazikika kuti ithetse ntchito zosiyanasiyana. Ngakhale tidaganiziridwa kutali ndi njira zonse zomwe zingagwiritsidwe ntchito, koma zokhazo zomwe zingafunikire. Pali mitundu iwiri ya chinthuchi: Kutengera ndi ku Array. Itha kukhala bwino kwambiri kuphatikiza ndi ena. Opangidwa mwanjira imeneyi amathetsa ntchito zovuta kwambiri.