Tora Maverengero Akawanda neExcel Array Formulas

Mumapurogiramu epadheseti akadai seExcel neGoogle Spreadsheets, ruvara rwuri ruzivo kana ruzhinji rwehutano hwehutano hunochengetedzwa mumasero ari pedyo mune pepaji.

Chirevo chemufananidzo ndeye chirevo chinowedzera kuverenga-sekuwedzera, kana kuwedzera-pane hutsika mune imwe kana mamwe mabira panzvimbo pane chinhu chimwe chete chinonyanya kukosha.

Nzira dzakasiyana-siyana:

• shandisa izwi rimwechete sezvinoita nguva dzose-ivo vose vanotanga nechiratidzo chakaenzana (=) somuenzaniso;
• shandisai masvomhu akafanana nevashandi;
• uye kutevera mutemo iwoyo wekushanda.

Array Formula uye Excel Mabasa

Vakawanda veExcel yakagadzirirwa mumabasa-akadai seSUM , AVERAGE , kana COUNT -can inoshandiswawo muurongwa hwemhando.

Panewo mabasa mashomanana-akadai seTATANYA basa-iro rinofanira kugara richinyorwa segadziriro kuitira kuti rishande zvakanaka.

Kubatsira kwemabasa mazhinji akadai se INDEX ne MATCH kana MAX uye IF inogona kuwedzerwa nekuvashandisa pamwe chete mumutsetse wemhando.

CSE Formulas

MuExcel, mazano akazara akakomberedzwa ne "curly braces" " {} ". Izvi hazvikwanisi kuiswa mukati, asi inofanira kuwedzerwa pane imwe nzira kuburikidza neCtrl, Shift, uye Enter keys shure kwekunyora fomu iri mumasero kana masero.

Nokuda kwechikonzero ichi, mazano akafanana dzimwe nguva anotumidzwa seCSE formula muExcel.

Kusiyana nemurairo uyu ndeye apo kusungurudzika kwekasa kunoshandiswa kuisa mhando senharo yebasa iro rinowanzo rine chinhu chimwechete kana sero reference.

Semuenzaniso, mumudzidzi wezasi unoshandisa VLOOKUP uye CHOOSE basa kuita sarudzo yekuchera mazano, mhando yakagadzirwa nokuda kweCOOSE function Index_num argument nekunyora mabhesi akakomberedzwa.

Matanho ekugadzira Mhando yeMapurisa

1. Isa chirairo;
2. Tora pasi Ctrl uye Shift keys pane keyboard;
3. Dhinda nekusunungura pikicha yekupinda kuti ugadzire urongwa hwese;
4. Bvisa Ctrl uye Shift keys.

Kana yakaitwa nenzira yakarurama, chirevo chacho chichakomberedzwa ne-curly braces uye sero rimwe nerimwe rakabata fomu richava nemugumisiro wakasiyana.

Kugadzirisa Array Formula

Chero nguva iyo nzira yakagadziriswa yakagadziriswa maziso anonyangarika anonyangarika kubva kumativi ose.

Kuti uvadzose shure, mazano ekugadzirisa anofanira kuiswa nekusvitsa Ctrl, Shift, uye Enter keys zvakare sezvakangoita apo mazano ekutanga akatanga.

Mitauro yeArray Formulas

Iko kune miviri miviri mikuru yemhando yekufananidzira:

• Multi-cell cell formula - iyo inomira inowanikwa mune imwe kero rimwe mumushandi webasa
• sero rimwechete rondedzero imwe nzira inobatanidza kuverenga kwakawanda mune imwe sero reeseji reeseji

Multi Cell Array Formulas

Kufanana nezita ravo rinoratidzira, mazita aya akawanikwa ari mumasero akawanda ekushanda mapepa uye anodzorerawo mhinduro semhinduro.

Mune mamwe mazwi, maitiro akadaro ari mune maviri kana kupfuura masero uye anodzorera mhinduro dzakasiyana mune imwe sero.

Zvinoita sei izvi ndeyokuti kopi imwe neimwe kana chiitiko chemuenzaniso wekuita unoita kuenzana kwakafanana mune imwe sero iri irimo, asi imwe neimwe yefomula inoshandisa dhiyanisi yakasiyana muhuwandu hwayo uye, naizvozvo, imwe neimwe yega inobereka migumisiro yakasiyana.

Muenzaniso we multiple multiple cell formula ndiwo:

{= A1: A2 * B1: B2}

Kana mufananidzo uri pamusoro apa uri mumasero eC1 neC2 mune pepa rekushanda zvino zvinotevera zvinotevera:

• iyo data iri muA1 yakawanda nemashoko ari muB1 nemigumisiro yakachengetwa muchitokisi C1
• iyo data iri muA2 inowanikwa nemashoko ari muB2 nemigumisiro yakachengetwa muchitokisi C2

Single Cell Array Formulas

Rudzi rwechipiri rwemhando dzakashandisa runoshandisa basa, rakadai seSUM, AVERAGE, kana COUNT, kuti iyananise kubudiswa kwema-multi-cell array formula kuti ive chinhu chimwe chete mune imwe sero.

Muenzaniso wekamuri imwechete yemazana yaizove:

{= SUM (A1: A2 * B1: B2)}

Iyi shanduro inowedzera pamwe chete chibereko cheA1 * B1 uye A2 * B2 uye inodzorera chiitiko chimwe chete mune imwe sero mupepa rekushanda.

Imwe nzira yekunyora urongwa huri pamusoro apa:

= (A1 * B1) + (A2 * B2)

Rwendo rweExcel Rwokutanga Mapurisa

Pasi apa zvakanyorwa mazita ezvidzidzo zvinowanikwa neExcel mazita.

• Idzidziso yekutanga inobatanidza mamiriyoni esero mavara mapepa
• Mimwe mitanhatu inotevera inodzidzisa inenge imwe sero mazita maitiro ekushandisa mabasa akasiyana eEexcel
• The last tutorial is on TRANSPOSE function

01 yegumi

Excel Multi Cell Array Formula

Sero yakawandisa kana kuti mizhinji yemakiromendi mashandisirwo emhando yakarongwa ndeye nzira yakarongwa inowanikwa mune imwe kero rimwe mupepaiti . Izvo zvakaenzana zvinowanikwa mumasero akawanda uchishandisa dhiyamusi yakasiyana-siyana yemhando imwe neimwe. Zvimwe »

02 yegumi

Excel Single Cell Array Form For Step by Step Tutorial

Chengeteri dzemafomu maitiro akawanzo kutanga aita masero masero ekuverenga (sekudai kuwedzera) uye zvino shandisa basa rakafanana neAVERAGE kana SUM kuti iyananise kubuda kwezvakaitwa muhumwe chete. Zvimwe »

03 wegumi

Ramba Kukanganisa Maitiro Akanaka paunowana IVERVER

Iyi nzira yakashandiswa inogona kushandiswa kuwana huwandu hwehuwandu hwemashoko akangwara paunenge usina hanya nemaitiro akakanganisa akadai se # DIV / 0 !, kana #NAME?

Inoshandisa AVERAGE basa pamwe neFI uye ISNUMBER inoshanda. Zvimwe »

04 yegumi

SUM's SUM IF Array Formula

Shandisa basa reSUM uye IF inoshanda mune imwe nzira yekuverenga pane kuverenga masero ematafura anosangana imwe yemamiriro akawanda.

Izvi zvakasiyana neExcel COUNTIFS basa iro rinoda kuti zvinhu zvose zvigadziriswe zvigadziriswe vasati verengerwe.

05 of 10

Excel MAX IF Array Formula Yokuwana Nhamba Yakanyanya Kupfuura Nayo kana Inonyadzisa

Iyi tutori inosanganisira MAX basa uye IF inoshanda mune imwe nzira yakagadzirisa inowana hukuru kana huwandu hunokosha hwehuwandu hwemashoko apo imwe tsanangudzo inosangana. Zvimwe »

06 of 10

Excel MIN IF Array Formula - Tsvaga Chinyanya Chidiki Chakanaka kana Nhamba Isina Hanya

Kufanana neshoko riri pamusoro apa, iri rinobatanidza MIN function uye IF inoshanda nenzira yakarongwa kuitira kuti uwane shoma shoma kana kuti zvishoma zvigadziro rwehuwandu hwemashoko apo imwe tsanangudzo inosangana. Zvimwe »

07 pa10

Excel MEDIAN IF Array Formula - Tsvaga Mukati kana Median Value

Basa reMEDIAN muExcel rinoona kukosha kwepakati pezita re data. Nokuzvibatanidza neI IF basa mumutambo wakafanana, mutengo wepakati wemapoka akasiyana e data yakabatana inogona kuwanikwa. Zvimwe »

08 yegumi

Kutsvaga Purogiramu neMatongerwo Akawanda muExpcel

Nokushandisa shanduro yakagadziriswa nzira yekutsvaga inogona kusikwa inoshandisa nzira dzakawanda kuti uwane ruzivo mune d database. Iyi mazano akabatanidzwa anosanganisira kunyorera MATCH uye INDEX mabasa. Zvimwe »

09 yegumi

Excel Kuruboshwe Kurapa Formula

Basa reVLOOKUP rinowanzotsvaga deta iri mumakorani kurudyi, asi nekuisanganisa neCOOSE basa re eft lookup fomu inogona kusikwa iyo ichatsvaga mapuranga e data kuruboshwe rweLookup_value argument. Zvimwe »

10 pa10

Kudhinda kana Flip Rows kana Columns of Data muExpcel

ICHINYANYA basa rinoshandiswa kukopa dhesi iri mumutsara muhurukuro kana kopi yedata iri mukorodhe mumutsara. Iri basa nderimwe remazana mashomanana muExcel rinofanira kushandiswa nguva dzose seurongwa hwemhando. Zvimwe »