Painless Excel yakajairwa autofilter pane zvinopfuura 2 maitiro

Excel filter pane zvinokwana 2 zvinotarisirwa

Kana iwe uine Excel pepa iyo iwe yaungada kusefa pane akawanda maitiro, iwe une nzira nhatu dzakasiyana, zvichienderana kana iwe uchida kusefa pane imwe, mbiri, kana kuwanda maitiro, mune iyo mamiriro iwe unoda kushandisa iyo yepamusoro firimu Excel mukati kuwedzera neExcel wildcards kunatsa mafirita.

Zvinokwanisika kushandisa mafiriji akawanda muExcel, neAustofilter, kuitira kuti upfamende inoshandiswa kushandesiti yakasununguka, uye uwane Excel mitezo yakawanda pane imwechete kana mamwe mazamu.

Mushure mekushandisa imwe yeiyi matangi akatsanangurwa mune iyoyo Excel rubatsiro online chinyorwa, iwe unozokwanisa kuisa mamwe mabasa epamberi eExcel pane mhedzisiro yakadai sekuverenga nhamba yemasero mumhedzisiro yakadhiza pane imwechete maitiro, kuita Vlookup yepamusoro muExcel ne iyo yakapetwa kaviri dhata, kana semuenzaniso  kuverenga nhamba yezvinoitika   kubva kuExcel yepamusoro firita yakawanda zviyero pane imwe safu yakashandiswa.

1 - Excel 2013 filter pane imwe nzira

Nzira yekutanga uye yakareruka, kufuta pane imwechete kana kupfuura 2 zvinotarisirwa, ndeyokushandisa firimu mumenyu Data => Futa.

Nefaira yakaiswa, pane iyo kwikholamu iwe yaunoda kusefa, penya museve, uye, mune Yekutsvaga shamba, pinda tambo iwe yauri kutsvaga kusanganisira inozoitika Excel mhuka dzesango:

• ABC yezvinyorwa zvine ABC,
• ABC * yezvinyorwa zvinotanga neABC,
• * ABC yezvinyorwa zvinoguma ne ABC.

Iyi ndiyo nzira yekuita nayo Excel filter yakawanda ma column, nekusarudza firiti inoshanda mune imwe koromo maererano ne data yakachengetwa muhomwe iyoyo.

Zvinotokwanisika kuita Excel filter yakawanda mitemo, sezvo imwe nzira inogona kusarudzwa nehomwe, uye inogona kuva yakasiyana kune imwe neimwe yavo.

2 - Dhinda firimu mu Excel

Uine firiji yakashandiswa, pane imwe column yaunoda kufuta, tsvaga pamuseve, uye, muMagwaro Filters menyu, sarudza Iine chinangwa.

Mubhokisi rakashama, unogona kuisa imwechete kana miviri nzira - kana ukasarudza OR, zvose zviri zviviri zvichashandiswa. Kana ukasarudza AND (nekutadza), zvinyorwa chete zvinosangana nemitemo miviri zvichasarudzwa.

Nokudaro kukubvumira kuti uite an Excel kaviri firiji pane spreadsheet yako, uye ndeyekuti unogona sei kuisa firimu muExcel pane imwe yendarama.

3 - Excel yepamberi firita yakawanda maitiro khoramu imwe

Iva excel Pro: Joinha kosi yedu!

Simudza hunyanzvi hwako kubva kuLovice kuenda kuHamba NeGamba Pedu 365 Basics Course, rakagadzirirwa kukuita iwe nyanzvi mune zvikamu zvishoma.

Nyoresa pano

Kuti ukwanise kuita Excel fileri kupfuura zvinotarisirwa 2, unofanirwa kuumba imwe koromo neyo chaiyo musoro iyo seyendori yaunoda kufuta-mumuenzaniso wedu, korombo ndiro zita-uye isa imwe tsanangudzo yekutsvaga nemutsara uri pasi apa. Zvose zvinosarudzwa zvinoshandiswa se-OR-zvinoreva, zvigumisiro zvichafananidza chero ipi zvayo.

Zvadaro, sarudza chinyorwa chaunoda kufuta, sarudza Data menu => Shanduro yakadzama muGadzira & Filter bhokisi, chengeta pa Criteria range icon, uye sarudza zvinotenderwa masero - kwete muromo wose, chete iyo inotora data inotanga ne imwechete column column se data kuti ufunge.

Uye voilà! Ona pazasi semuenzaniso, rondedzero yehotera yakavezwa kumahotera ese kubva kuHoliday Inn, Crowne Plaza, Radisson, kana Novotel, ine fafitera yekufambisa Excel 2013, zvichikonzera Excel tsika autofilter inopfuura 2 maitiro, anonzi zvakare Excel advanced faira akawanda maitiro imwe ikhoramu imwe seyakasiyana nzira yacho ichishandiswa zvakafanana panguva imwecheteyo kwikholamu imwe.

The Excel custom filter yepamusoro pe 2 inotungamirwa inoguma inoguma nekutumira chete kunenge kune mamwe mafiritsi ari kuratidzwa.

Ona pasi apa mugumisiro nemafuta akawanda eExcel akashandiswa.

Excel custom filing multiple criteria

Izvo zvinokwanisika muExcel kupurinda pane zvinopfuura zviviri maitiro, nekumisikidza ikholamu ine tsika dzekutsvaga, iyo inofanirwa kunyorwa zita racho seyakanyanya sekoramu iyo iyo firita inofanira kuiswa.

Zvadaro, sarudza chinyorwa kuti uone. Vhura menyu> data> filter> yakapfuura.

Sarudza iyo uremu hwekuyera, iyo imwe dura ine zita rimwe chete, uye Excel yakafambiswa mugero yakawanda mativi imwe ikhoramu ichaiswa pane yekutanga khoramu, yakafetwa nemhando dzakawanda.

Mibvunzo Inowanzo Bvunzwa

Ndeipi nzira iri nyore yekuita Excel tsika firita kupfuura 2 mamiriro?

Nzira iri nyore yekuenda kuFilter ne 2 maitiro ndeyekuisa faira mu data - firita menyu. Uchishandisa iyo filter, tinya museve muColumn iwe yaunoda kufefetera, uye mubhokisi rekutsvaga, nyora tambo yauri kutsvaga, inosanganisira excels mhuka.

Vashandisi vekusimudzira vanganyorera sei tsika autofilter yekugadzirisa data zvichibva pane zvinopfuura zviviri zvinodarika maviri maitiro asina bhuku rakawanda rekuputika?

Vashandisi vanogona kunyorera tsika autofilter kweanopfuura maviri maitiro nekushandisa iyo yepamusoro yefaira yefaira. Izvi zvinosanganisira kumisa maitiro ekumwe kune imwe nzvimbo mune yekushandira inotsanangura zvese zvinodikanwa maitiro, uye wozoshandisa iyo yepamusoro firita dialog kuti ishandise maitiro aya ku data renji.

Zadzisa 2019 Excel yeVatanga mune vhidhiyo