Customarancin kayan aikin kwastomomi na rashin jin daɗi akan abubuwa fiye da 2

Excel tace fiye da 2 sharudda

Idan kuna da takardar Excel wacce zaku so tace akan sharudda dayawa, kuna da hanyoyi daban-daban guda uku, gwargwadon idan kuna son yin bayani akan daya, biyu, ko kuma sharudda dayawa, a cikin wannan yanayin kuna buƙatar amfani da matattarar haɓaka Excel a cikin kari tare da Excel wildcards don tsaftace masu tace.

Yana yiwuwa a yi amfani da maɓuɓɓuka masu yawa a cikin Excel, tare da Autofilter, don samun samfurin da aka yi amfani da su a cikin ɓangaren budewa, sa'annan kuma sami Excel yayi ma'auni mai yawa a kan ɗaya ko fiye da ginshiƙai.

Bayan an yi amfani da ɗayan waɗannan dabaru da aka bayyana a cikin waccan taimakon na kan layi, za ku iya amfani da ayyukan gaba na Excel a kan sakamakon kamar ƙidaya adadin ƙwayoyin sakamakon sakamakon da aka ƙayyade bisa ƙa'idodi guda ɗaya, don yin Ci gaba mai zurfi a cikin Excel tare da bayanan da aka tace sau biyu, ko misali don ƙidaya yawan abin da ya faru daga ƙididdigar haɓaka ɗalibai na Excel akan shafi ɗaya shafi.

1 - Excel 2013 tace akan ka'idodi daya

Hanyar farko da mafi sauki, don tace akan ɗaya ko iyakar 2 ma'auni, shine a yi amfani da tace a menu na Data => Filter.

Tare da amfani da tace, akan shafi akan abin da kake son tacewa, danna kan kibiya, kuma, a cikin filin Bincike, shigar da kirtani da kake nema ciki har da kyakkyawan alamar:

• ABC don shigarwar dauke da ABC,
• ABC * don shigarwar farawa da ABC,
• * ABC don shigarwar da ta ƙare tare da ABC.

Wannan kuma hanya ce ta yin tarin Excel ta ginshiƙai masu yawa, ta hanyar zaɓar tace don amfani da shi a cikin kowane shafi game da bayanai da aka adana a wannan shafi.

Yana da yiwuwa a yi wani Excel ta yin amfani da ka'idoji masu yawa, kamar yadda za'a iya zaɓin ka'idodi guda ɗaya, kuma zai iya zama daban-daban ga kowane ɗayansu.

2 - Biyu tace a Excel

Tare da tace amfani, a shafi wanda kake so ka tace, danna arrow, kuma, a cikin Fassara menu, zaɓi Ya ƙunshi wani zaɓi.

A cikin akwati, zaka iya shigar da ɗaya ko biyu ma'auni - idan ka zaɓi KO, za a yi amfani da waɗannan duka. Idan ka zaɓi DA (ta tsoho), kawai shigarwar da za a hadu da ka'idoji guda biyu za a zaɓa.

Sabili da haka ƙyale ka ka yi takarda ta Excel ta biyu a kan maƙunsarka, kuma shine yadda zaka ninka tace a Excel a kan guda guda.

3 - Excel haɓaka matattara mai faɗi ɗaya shafi

Kasance mai kyau Pro: Kasance da karatunmu!

Daukaka kwarewarku daga novice ga gwarzo tare da muxin muxinmu na 365, wanda aka tsara don sanya ku ƙwarewa a cikin 'yan zaman a cikin' yan zaman.

Rijista a nan

Domin iya yin takarda Excel fiye da 2 ma'auni, dole ne ka ƙirƙira wani shafi tare da ainihin taken kai tsaye a matsayin shafi da kake son tace - a cikin misalinmu, ginshiƙan suna - kuma sanya shafukan bincike ɗaya ta layin da ke ƙasa. Za a yi amfani da dukan zabin zane kamar ma'anar OR - ma'ana, sakamakon zai dace da kowannensu.

Sa'an nan, zaɓi shafin da kake so ka tace, zaɓi Data menu => Babban zaɓi a cikin Fassara & Filin Filter, danna kan Alamatattun layi, sannan kuma zaɓi ka'idojin Kwayoyin - ba dukan shafi ba, kawai ka'idodin bayanai farawa tare da maɓallin shafi na ɗaya kamar yadda bayanai za su tace.

Kuma voilà! Duba ƙasa misali, jerin sunayen otal ɗin an tace su zuwa duka otal daga ɗayan Holiday Inn, Crowne Plaza, Radisson, ko Novotel, tare da ingantaccen matattakalar Excel 2013, wanda ya haifar da ƙayyadadden tsarin halayen Excel fiye da 2, wanda kuma ake kira da Excel mai haɓaka. tace sharuɗɗa da yawa a shafi ɗaya kamar yadda ake amfani da ma'auni daban-daban lokaci guda a kan wannan shafi.

Aikin na Excel tacewa fiye da 2 ma'auni ya ƙunshi kawai shigarwar dauke da duk wani filfurin da aka nuna.

Dubi sakamakon ƙasa tare da maɓallai mai yawa na Excel.

Custom Excel ta ƙayyade ka'idodi masu yawa

Zai yiwu a cikin Excel a juye abubuwa sama da sharudda guda biyu, ta hanyar kafa shafi tare da dabi'u don bincika, wanda dole ne a sanya sunan daidai kamar yadda shafi wanda dole ne a yi amfani da matatar.

Sa'an nan, zaɓi shafi don tace. Bude menu> bayanai> tace> ci gaba.

Zaɓi kewayon ma'aunin tsari, ɗayan shafi mai suna iri ɗaya, kuma Excel naɗaɗɗen haɓaka matattara masu yawa ana amfani da ma'auni ɗaya shafi akan shafi na farko, ana haɗa su da ma'auni masu yawa.

Tambayoyi Akai-Akai

Menene hanya mafi sauƙi da za a iya amfani da tace al'ada ta al'ada fiye da yanayi 2?

Hanya mafi sauki don tacewa ta hanyar sharuɗɗa guda biyu ita ce amfani da tacewa a cikin bayanan - Menu Menu. Yin amfani da tace, danna kibiya a cikin shafi da kake son tace, kuma a cikin akwatin binciken, rubuta igiyar da kake nema, gami da buttelin.

Ta yaya masu amfani da kara autooder don daidaita bayanai dangane da sharuɗɗa fiye da ƙa'idoji da yawa ba tare da tace manzon ba?

Masu amfani zasu iya amfani da Auteriber na al'ada don abubuwa biyu ta amfani da fasalin matatar mai ci gaba. Wannan ya shafi kafa ka'idodin ka'idodi a cikin takardar aiki wanda ya fassara duk ka'idodin da ake so don amfani da waɗannan ka'idojin zuwa kewayon bayanan.

Cikakken 2019 Excel ga Masu farawa a bidiyo