Basa amai muExcel

Sezvaunoziva, Excel ine zvishandiso zvakawanda zvekushanda nemazyi. Mumwe wavo ndiye muffer basa. Nemushandi uyu, vashandisi vanoita kunge vakawandisa matrices akasiyana. Ngatitsvagei kushandisa iyo yekushandisa chiitiko ichi mukuita, uye ndeapi manzwa makuru ekushanda nazvo.

Uchishandisa muffer anoshanda

Basa guru reAmai rinouya, sezvataurwa pamusoro, ndere kuwanza madzinza maviri. Inoreva chikamu chemasvomhu masvomhu.

Iyo syntax yeiyi ficha iri seinotevera:

= Amai (array1; array2)

Sezvatinoona, anoshanda ane nharo mbiri - "Army1" uye "kurongedza". Imwe neimwe yemakakava kureva kune imwe yemakuru, iyo inofanira kuwedzera. Izvi ndizvo chaizvo izvo zvinoitwa nemushandi pamusoro apa.

Mamiriro ezvinhu akakosha ekushandiswa kwemamms ndeyekuti huwandu hwetambo hwemitambo yekutanga Matrix anofanira kuenderana nehuwandu hwemakoramu ezvikamu zvechipiri. Pane imwe nyaya, kukanganisa kuchapihwa semhedzisiro yekugadzirisa. Zvakare, kuitira kuti udzivise kukanganisa, hapana chimwe chezvinhu zvevese maoko ngano zvinofanirwa kunge zvisina chinhu, uye ivo vanofanirwa kuve zvizere zviine nhamba.

Matrix Muwande

Iye zvino ngatimboongororai pamuenzaniso chaiwo, sezvamunogona kuwanda matrices maviri, uchishandisa muffer anoshanda.

1. Vhura iyo Excel pepa pane iyo maviri matrices atowanikwa kare. Isu tinoratidza nzvimbo yemasero asina chinhu pairi, iyo yakatwasuka ine muumbi wayo huwandu hwetambo dzematanho ekutanga, uye nekukasira huwandu hwemakoramu ezvikamu zvechipiri. Tevere, isu tinodzvanya pane "isa basa" icon, iyo iri pedyo nedesi yemutsara weFormasi.



2. Iyo mabasa wizard inotanga. Tinofanira kuenda kuChikamu "masvomhu" kana "yakazara alfabhethi rondedzero". Mune runyorwa rwevashandi, zvinodikanwa kuti uwane zita rekuti "Muffer", simbisa iyo uye tinya "OK" bhatani, iro riri pazasi pehwindo iri.



3. Hwindo rekupokana kweanoshanda muMumbeti anotangwa. Sezvatinoona, ine minda miviri: "Army1" uye "kurongedza". Mune yekutanga inofanira kutsanangura marongero ematare ekutanga, uye mune yechipiri, zvichiteerana, yechipiri. Kuti uite izvi, isa iyo inotuka mumunda wekutanga. Ipapo isu tinogadzira clamp neiyo kuruboshwe bhatani bhatani uye sarudza nzvimbo yemasero ine yekutanga matrix. Mushure mekuita maitiro aya ari nyore, marongi acharatidzwa mumunda wakasarudzwa. Chiito chakafanana chinoitwa nemunda wechipiri, nguva ino chete, nekubata bhatani rekuruboshwe, isu tinoratidza yechipiri matrix.

   Mushure mekunge kero yezvese matrices zvakanyorwa, usamhanye kudzvanya iyo "OK" bhatani, yakaiswa muchikamu chewindo. Chokwadi ndechekuti tiri kubata nebasa rezvinyorwa. Iyo inopa kuti mhedzisiro yacho haina kuratidzwa muchitokisi chimwe, semabasa akajairika, asi pakarepo mune yakazara huwandu. Naizvozvo, kuburitsa iyo data yekugadzirisa, ichishandisa inoshanda, haina kukwana kudzvanya kiyi yekupinda, kuisa mhirizhonga mufomula row, kana tinya pawindo rezvipfuyo pari zvino. Iwe unofanirwa kunyorera kudzvanya CTRL + Shift + Enter kiyi musanganiswa. Isu tinoita izvi maitiro, uye "ok" bhatani haribate.



4. Sezvatinogona kuona, mushure mekutsikirira iyo yakadhindwa keyboard kusanganisa, nharo dzepfungwa dzeanoshanda, mamset yakavharwa, uye huwandu hwemasero, hwatakagovera padanho rekutanga remurayiridzo uyu, rakazadzwa nedata. Iyi ndiyo tsika iyo mhedzisiro yekuwedzera imwe matrix kune imwe, iyo yaiita muffer anoshanda. Sezvatinoona, muFormula mutsetse, basa racho rinotorwa mumakonzo makonzo, zvinoreva kuti ndezvevashandi vevashandi vairwisa.



5. Asi zvakanyatsojeka kuti mhedzisiro yekugadzirisa iyo basa kune moms ndeye yakarongeka yakarongeka, inodzivirira imwe shanduko kana zvichidikanwa. Paunoyedza kuchinja chero nhamba yemugumo yemushandisi, ichave yakamirira meseji iyo inozivisa kuti hazvigoneke kuchinja chikamu chehurongwa hwekurongeka. Kuti ubvise kusagadzikana uku uye kushandura rondedzero isingachinji kune yakajairwa huwandu hwe data aunogona kushanda nayo, ita matanho anotevera.

   Isu tinosimbisa iyi huwandu uye, tichiri muTabha yeTab, tinya pa "Kopa" icon, iyo iri mu "Exchange Buffer" Toolbar. Zvakare, pachinzvimbo chekushanda uku, unogona kushandisa iyo CTRL + C kiyi yakaiswa.



6. Mushure meizvozvo, pasina kubvisa kusarudzwa kubva kune renji, tinya pairi neiyo kurudyi mbeva bhatani. Mune yakavhurwa mamiriro menyu mune "isa marongero" block, sarudza "kukosha" chinhu.



7. Mushure mekuita ichi chiito, iyo yekupedzisira matrix haichazorwiswe seyakajairika estextive renji uye inogona kuitwa zvine hukama hwakasiyana siyana.

Chidzidzo: Shanda neArrays muExcel

Sezvauri kuona, iyo Amai inoshanda inokubvumira kukurumidza uye nyore nyore muExcel maviri matrices pane mumwe nemumwe. Syntax yebasa iri iri nyore uye vashandisi havafanirwe kuve nematambudziko nekupinda data muhwindo rekupokana. Dambudziko chete rinogona kuitika kana richishanda nemushandi uyu ari munyatsoona kuti inomiririra basa renzvimbo, uye saka zvine zvimwe zvinhu. Kuti aratidze mhedzisiro, sarudza rondedzero inoenderana papepa, uye mushure mekupinda nharo dzekuverenga, shandisa mukana wakakosha musanganiswa we data - CTRL + Shift + Shift.