Xannuun aan caadi ahayn oo tayo sare leh oo ah 'Autofilter' oo ka badan 2 shuruudood

Excel filter ka badan 2 shuruudood

Haddii aad haysato warqad tayo leh oo aad jeclaan lahayd inaad ku shaandhayso dhowr shuruudood, waxaad leedahay seddex qaab oo kala duwan, taas oo kuxiran haddii aad rabto inaad ku shaandhayso hal, laba, ama shuruudo badan, taas oo markaa u baahan inaad isticmaasho filter-ka tayo sare ee gudaha Waxaa intaa dheer oo ay la socdaan kuwa loo yaqaan 'super wildards' si loo safeeyo miirayaasha.

Waxaa suurtogal ah in la isticmaalo shaandhooyin kala duwan oo ku yaala Excel, oo leh Autofilter, si aad u hesho farsamoyaqaan sare oo loo adeegsado xisaab furan, oo aad u hesho mawduuca ku dhigma shuruudo badan oo ku saabsan mid ama kabadan.

Markaad codsato mid ka mid ah khiyaamadaas oo lagu sharraxay maqaalkan caawinta leh ee khadka tooska ah, waxaad awood u yeelan doontaa inaad adeegsato howlo tayo sare leh oo tayo sare leh natiijooyinka sida tirinta tirada unugyada natiijooyinka la sifeeyay hal shuruudo, si aad u sameyso Muuqaal sare oo tayo sare leh xogta laba la sifeeyay, ama tusaale ahaan in la tiriyo tirada dhacdooyinka ka soo baxa tayada sare ee tayo sare leh oo ku saleysan hal column la dalbaday.

1 - Falanqaynta Excel 2013 oo ku saabsan hal shuruud

Habka ugu horreeya uguna fudud, si aad ugu fayl-gareeyso hal ama ugu badnaan 2 shuruudood, waa inaad ku daboosho shaashadda menu Data => Filter.

Marka la adeegsado shaandhaynta, khaanadda aad rabto inaad ku shaandhayso, dhagsii fallaadha, oo, Meesha Raadinta, geli xargaha aad raadineyso oo ay ku jiraan calaamadaynta ugu dambeyntii:

• ABC loogu talagalay gelitaanka ay ku jiraan ABC,
• ABC * ee loogu talagalay in laga bilaabo ABC,
• * ABC ee loogu talagalay kudhawaadinta ABC.

Tani sidoo kale waa habka loo sameeyo shaandhaynta shaandhaynta muraayadaha kala duwan, adoo dooranaya shaandhada si aad u dalbato marxalad kasta oo ku saabsan xogta lagu kaydiyay qaybtaas.

Xitaa waa suurtagal in la sameeyo shaandhaynta Excel ee shuruudaha kala duwan, maaddaama hal shuruudo lagu dooran karo jaantus, waana mid ka duwan mid kasta oo ka mid ah.

2 - Fiiri laba jeer ah ee Excel

Iyada oo la xarriiqay filter, on column ee aad rabto in aad xayeysiiso, riix fallaadhaha, iyo, in menu Filters menu, dooro Contains option.

Sanduuqa furan, kadib waxaad geli kartaa mid ama laba shuruudood - haddii aad doorato AMA, labadaba waa la isticmaali doonaa. Haddii aad dooratid IYO (marka la eego), kaliya gelitaanka labada shuruudood ayaa la dooran doonaa.

Saas oo kuu ogolaaneysa inaad sameyso shaandhada shaandhada ee 'Excel' ah oo ku qoran khariidadaada xisaabta, waana sida loo labalaabi karo shaashadda Excel hal tiir.

3 - tayo sare oo tayo sare leh oo shaandhayso hal hal sadar

Noqo Prolel Pro: Ku soo biir koorsadeena!

U dhaaf xirfadahaaga Novice si geesinimo leh oo leh koorsadeena 365 ee caadiga ah, oo loogu talagalay in lagugu dhigto mid aad ku wanaagsan oo aad ku qanacsan tahay.

Halkan ka qor

Si aad u awooddo inaad sameyso shaashadda Excel ka badan 2 shuruudood, waa inaad sameysaa mid kale oo leh saxan isku mid ah sida tiirarka aad rabto inaad sifudbiso - tusaale ahaan, tiirkayaga waa magac - oo ku rid shuruudaha raadinta ee xariiqda hoose. Dhammaan shuruudaha xulashada waxaa loo isticmaali doonaa inay yihiin OR - macnaha, natiijooyinka waxay u dhigmaan mid kasta oo iyaga ka mid ah.

Kadib, dooro jaantuska aad rabto inaad xareeyso, dooro Xogta Macluumaadka => Fiiri Heerka Xulashada & Filtarka, guji Criteria range icon, oo dooro unugyada shuruudaha - ma aha santuuqa oo dhan, kaliya macluumaadka shuruudaha oo ka bilaabmaya madaxa isku midka ah sida xogta shaandhaynta.

Iyo voilà! Eeg tusaalaha hoose, liistada hoteelka ayaa laga shaandheeyay dhamaan hoteellada midkood Holiday Inn, Crowne Plaza, Radisson, ama Novotel, oo leh filter tayo sare leh 2013 2013, taasoo dhalisay tayo gaar ah oo tayo sare leh oo ka badan 2 shuruudood, oo sidoo kale loo yaqaan Excel Advanced. shaandhayso halbeegyo badan hal sadar iyada oo shuruudaha kaladuwan lagu dabakhayo isla hal column.

Foornada caadada ah ee Excel ee ka badan 2 shuruudood waxay ka imaaneysaa oo keliya natiijooyinka ku jira mid ka mid ah shaandhada lagu soo bandhigay.

Fiiri natiijada ka dib mawduuca mashiinka kala duwan ee Excel.

Habka Excel u xaddidan shuruudaha kala duwan

Waxa suuragal ah in Excel lagu shaandheeyo wax ka badan laba shuruudood, adoo dejinaya sadar leh qiimayaal lagu raadiyo, kaas oo ah in si sax ah loogu magacdaro safka ay tahay in shaashadda lagu dabaqo.

Kadib, dooro santuuqa si aad u xaddidid. Furo liiska> xogta> filinka> horumarsan.

Xulo xadka cabirka, safka kale ee leh isla magac, iyo tayo sare oo tayo sare leh filter qeybo badan oo hal sadar ah ayaa lagu dabaqi doonaa safka hore, oo lagu shaandheeyay shuruudaha badan.

Su'aalaha Badanaa La Isweydiiyo

Waa maxay habka ugu fudud ee lagu shaandhadaa wax ka badan 2 shuruudood?

Sida ugu fudud ee loo miiraa 2 shuruudood ayaa ah in lagu dabaqo shaandhada xogta - shaandhada shaashadda. Adigoo isticmaalaya shaandhada, dhagsii fallaarta safka aad rabto inaad shaandhayso, iyo sanduuqa raadinta, ku qor xargaha aad raadineyso, oo ay ku jiraan xargaha axdigga.

Sidee bay isticmaaleyaasha Excel ugu dalban karaan caado u ah autofilter si ay u kala soocaan macluumaadka ku saleysan in ka badan laba shuruudood oo aan shaandhayn ku-shaandhayn?

Isticmaalayaasha ayaa dalban kara caadada u ah autofilter in kabadan laba shuruudood iyadoo la adeegsanayo muuqaalka filterka heerka sare. Tani waxay ku lug leedahay dejinta shuruudaha u dhexeeya meelo kale oo xaashi ah oo qeexaya dhammaan shuruudaha la doonayo, ka dibna u adeegsiga wadahadalka filterka heerka sare ah si loo isticmaalo shuruudahan tirada xogta.

Dhameystiran 2019 Excel for bilowga fiidiyowga