Basa rakajairwa rinomuka nguva nenguva pamberi pemushandisi wega wega weExcel kuenzanisa masara maviri nedata uye kuwana mutsauko pakati pawo. Nzira yekugadzirisa, munyaya iyi, inotarirwa nemhando yekutanga data.
Sarudzo 1. Synchronous Lists
Kana mazita acho akawiriraniswa (akarongwa), saka zvese zvinoitwa zviri nyore, nekuti zvinodikanwa, kutaura zvazviri, kuenzanisa kukosha mumasero ari padyo emutsara wega wega. Sesarudzo yakapusa, isu tinoshandisa fomula yekuenzanisa kukosha, iyo inoburitsa hunhu hwe boolean pane zvinobuda. TRUE (CHOKWADI) or KUNYEPA (NHEMA):
Huwandu hwekusawirirana hunogona kuverengerwa neformula:
=SUMPRODUCT(—(A2:A20<>B2:B20))
kana muChirungu =SUMPRODUCT(—(A2:A20<>B2:B20))
Kana mhedzisiro iri zero, zvinyorwa zvakafanana. Zvikasadaro, vane misiyano. Iyo formula inofanirwa kuiswa seyakarongwa fomula, kureva mushure mekupinda fomula muchitokisi, usadzvanya pinda, Uye Ctrl + Shift + Pinda.
Kana iwe uchida kuita chimwe chinhu nemasero akasiyana, ipapo imwe nzira yekukurumidza ichaita: sarudza makoramu ese uye dzvanya kiyi F5, ipapo pahwindo rakavhurwa bhatani Highlight (Special) - Mitsara yakasiyana (Mitsara yakasiyana). Mune shanduro dzichangoburwa dzeExcel 2007/2010, unogona zvakare kushandisa bhatani Tsvaga uye sarudza (Tsvaga & Sarudza) -Kusarudza boka remasero (Enda kuSpecial) Tab Home (Musha)
Excel inosimbisa masero anosiyana mune zvemukati (nemutsara). Zvino vanogona kugadziriswa, semuenzaniso:
- zadza neruvara kana neimwe nzira inooneka fomati
- zvakajeka nekiyi Kudzima
- zadza zvese kamwechete neukoshi hwakafanana nekuipinda nekudzvanya Ctrl + Pinda
- bvisa mitsetse yose nemasero akasarudzwa uchishandisa murairo Musha — Delete — Delete mitsara kubva pashizha (Kumba - Delete - Delete Rows)
- etc.
Yechipiri: Mazita Akakandwa
Kana mazita acho ari ehukuru hwakasiyana uye asina kurongwa (zvinhu zviri muhurongwa hwakasiyana), saka unofanira kuenda neimwe nzira.
Iyo yakapfava uye inokurumidza mhinduro ndeyekugonesa kujekesa kwemavara emisiyano uchishandisa conditional fomati. Sarudza ese marengeti ane data uye sarudza pane tab kumba - Conditional fomati - Simbisa mitemo yesero - Duplicate Values:
Kana ukasarudza sarudzo inodzokororwa, ipapo Excel icharatidza machisi mune yedu zvinyorwa kana sarudzo Yakasiyana – misiyano.
Kuratidzira kwemavara, zvisinei, hakusi nyore nguva dzose, kunyanya kumatafura makuru. Zvakare, kana zvinhu zvichigona kudzokororwa mukati mezvinyorwa pachazvo, saka nzira iyi haishande.
Neimwe nzira, unogona kushandisa basa COUNTIF (COUNTIF) kubva muchikwata Statistical, iyo inoverenga kuti kangani chinhu chimwe nechimwe kubva parunyorwa rwechipiri chinoitika mune yekutanga:
Zero inobuda inoratidza misiyano.
Uye, pakupedzisira, "aerobatics" - unogona kuratidza misiyano mune imwe rondedzero. Kuti uite izvi, iwe uchafanirwa kushandisa array formula:
Zvinotaridzika kutyisa, asi anoita basa nemazvo 😉
- Simbisa zvakapetwa murunyoro neruvara
- Kuenzanisa mativi maviri nePLEX yekuwedzera
- Kurambidza kuisa zvirevo zviviri