Imizekelo ye "SHERei" umsebenzi kwi-Excel

I-Syntax kunye nendalo

Umsebenzi ukhululekile, kuba phantse itafile nganye, kuyimfuneko ukubala inani lamanani kwiiseli, ukungahoyi amaxabiso angawa phantsi kweyona meko iphambili. Enkosi kule fomula, ukubala akunangxaki kwaye ixesha elide. Umsebenzi woyilo oqhelekileyo ubonakala ngathi = cwaka; Uluhlu; Uluhlu; Ukuba idatha kwi "Uluhlu lwesishwankathelo" lilahlekile, zonke iiseli ezibandakanyiwe kwi "Uluhlu" ziya kutshekishwa.

Siza kuzihlaziya iimpikiswano ezimbini ezisele - "Uluhlu" kunye "neNgcebiso". I-fits yokuqala yeeseli (A1: A100) ilingana (A1: A100), eya kuthi ihlolwe kwaye ithelekiswa nemeko. Kwi "Ikhrayitheriya", umsebenzisi uzisa le meko, xa usenza iseli iba yenye yeemeko. Oku kunokuba yimeko yokungalingani kwamanani (50) okanye ukuthotyelwa kombhalo ochaziweyo ("isicatshulwa"). Ukwenza lula ukwenziwa kokufakwa kweengxoxo zempikiswano, vula iwindows yemizobo "impikiswano" kwaye usete yonke imeko eguqukayo kwimihlaba eyahlukeneyo.

Akukho mizekelo emininzi eyahlukeneyo, iinkalo zokuzaliswa kwayo zikufanele ukuba ziqwalaselwe xa umsebenzi uthe cwaka, emva koko uya kufumanisa ukuba isiseko kwaye sithandwa kakhulu.

Umsebenzi uthule cwaka phantsi kwemeko yokungalingani

Umzekelo wokuqala kukusetyenziswa komsebenzi womsebenzi, ngokuxhomekeka ekubeni inani le-hit kufuneka libe likhulu, ngaphantsi okanye lingalingani kwinani elichaziweyo. Nge-syntax enjalo, umsebenzi ujonga zonke iiseli zoluhlu oluchaziweyo kwaye kuthathela ingqalelo ilungele kuphela. Incwadana yemigaqo ukuyibhala ngebala legalelo linamacandelo aliqela:

1. Chonga uluhlu lweeseli eziwela kwifomula, siya kuba nenzuzo yenyanga.



2. Qala ukungena kwimiyalelo yayo kwicandelo lokufaka ngokubhala.



3. Yenza i-Bracket yokuvula kunye nokuvala apho ufaka khona uluhlu lweeseli ezikhethiweyo, umzekelo C2: C25. Emva koko, qiniseka ukuba usayine; Oko kuthetha ukuphela kwengxoxo.



4. Vula iikowuti kwaye uchaze imeko yokuba kwimeko yethu iya kuba njalo> 300000.



5. Ngokukhawuleza emva kokucinezela iqhosha le-Enter, umsebenzi wenziwe wasebenza. Kwi-skrini, kucacile ukuba kuphela iiseli ezimbini kuphela ezihambelana nemeko> 300000, ngenxa yoko, ifomula ishwankathela amanani abo kunye nemiboniso kwibhloko eyahlukeneyo.

Ngasentla, inye kuphela imizekelo ethathelwe ingqalelo ngengozi imeko yengozi. Akukho nto iya kuthintela nantoni na yokufaka ezinye izinye amaxabiso, yandise okanye inciphise uluhlu-Ifomula iya kuhlala iqwalasele ixabiso ukuba imithetho ye-Syntax yaqwalaselwa.

Umsebenzi uthe cwaka, ngokuxhomekeke kwitekisi

Thatha umzekelo wesibini xa sele ethe cwaka esetyenziselwa ukubala imali kwiiseli ezixhomekeke ekuthotyelweni kolunye uluhlu lweebhloko. Oku kuya kuba luncedo, umzekelo, xa ixabiso lezinto zonke ezikwinqanaba elinye libaliwe, okanye iindleko zenkampani kwimivuzo kubasebenzi zibalwa kwizikhundla ezithile. Umzekelo wobhaliso kule meko usanomdla kwinyani yokuba i-syntax iguquka kancinci, kuba imeko iwela uluhlu lwesibini lweeseli.

1. Ngeli xesha, ukongeza kuluhlu lweeseli eziququzelela, zichonge ezo ndawo apho kukho amasibhalwana ekwimeko.



2. Qala ukurekhoda umsebenzi ukusuka ekuthiwa kwayo ngendlela efanayo njengoko ibonisiwe apha ngasentla.



3. Okokuqala, faka iziphumo zobhalo, ubeke; Kwaye ubeke imeko. Ke eli binzana kwifomathi ye-Syntact liya kufumana olu hlobo: A2: A25; "Septemba";



4. Njengengxoxo yokugqibela, ihlala ikhankanya uluhlu lweeseli, inani eliya kushwankathelwa kwimeko elungileyo. Sele uqhelene nemithetho yokurekhoda impikiswano enjalo.



5. Jonga umsebenzi wenyathelo. Sichaza inyanga kaSeptemba njengemeko kwaye ujonge itafile, eshwankathela amaxabiso amabini eeseli zetafile ezihambelana nayo. Idatha eseleyo xa ukhangele nje.

Faka igama okanye ufake igama lonke ibinzana, unikwe irejista yesimboli ukuze uzinze xa ubala amaxabiso afunekayo.

Umsebenzi we-smerevilm ngeemeko ezininzi

Sigqibezele uhlalutyo lomzekelo ngokhetho lwesithathu, xa iimeko zokusongeza ezininzi ngaxeshanye. Ngolu hlobo ukubalwa, umsebenzi ophantsi kwengqwalaselo lutshintshiwe nge-svmemalimn eguqulweyo, evumela ukuba ubeke ngaphezulu kwempikiswano enye, engenakuphunyezwa kwinguqulelo yokuqala. Enye yezona zinto zilula ngembalelwano epheleleyo ye-Syntactic yenziwe ngolu hlobo lulandelayo:

1. Thatha itafile apho kukho izinto ezintathu ezahlukeneyo kwidatha apho kwaye ngokweentlobo zabo. Le yinyanga, inzuzo iyonke kunye nenani leempahla ezithengisiweyo. Kwifomula ngeemeko ezininzi, kubalulekile ukuba zenze kuphela ezo ziphumo zengeniso, ezifunyenwe ngoSeptemba kunye nokuthengisa ngaphezulu kweeyunithi ezingama-29.



2. Qala ukungena kwintengiso esemgangathweni = i-swemonime, Vula iibrakethi kwaye ubhale ukuba loluphi uluhlu lweeseli oluya kushwankathelwa. Ungalibali ukuvala isibhengezo sophawu lwempikiswano;



3. Ukulandela impikiswano yesibini-iphakathi ngegama kwiseli. Ukurekhodwa kwale parameter kwakusele kuqwalaselwe ngaphezulu kwaye kunokubonwa kwakhona kwi-skrini.



4. Imeko yesithathu yimbalelwano yokungalingani kwangaphambili, esinaso esiziqhelanise ngayo ekuqaleni kwenqaku. Kwakhona ngefomathi efanayo, chaza uluhlu lwamaxabiso kunye nokungalingani ngokwakho kwizicatshulwa. Ungalibali ukubeka ibrakethi yokuvala, ngaloo ndlela ugqiba umsebenzi wokubhala.



5. Ngokupheleleyo, umgca walo msebenzi unefomu = svampmonime (C2: C25; A2: A25; "), kodwa unokufumana iziphumo ezilungileyo. Kusenokubonakala ngathi kunzima ukubhengeza impikiswano nganye kwaye kungadideka kubalinganiswa, kodwa ngendlela eyahlukileyo apho kungabikho ngxaki.

Ziyancwina kwaye ii-svamplims zezakwimisebenzi yezibalo ezinommeli ofanayo we-syntactic, kodwa zisetyenziswa kwiimeko ezahlukeneyo. Ukufunda ulwazi kuzo zonke iifomula ezithandwayo kwi-Excel, chaza kwizinto ezinxulumene noko.

FUNDA OKUNGAKUMBI