Marka aad ku shaqaynayso kayd xogeed oo waaweyn, waxaa faa'iido leh inaad ogaato sida loo shaandheeyo Google Sheets .

Waxaa jira laba siyaabood oo tan loo sameeyo. Waxaad isticmaali kartaa aragtida shaandhaynta ee liiska Google-ka ee xaashida^{(Google Sheets menu)} , kaas oo kuu ogolaanaya inaad habayso habab gaar ah oo aad ku shaandhayso xogta xaashida oo aad dib u isticmaali karto. Hab firfircoon oo dheeraad ah oo lagu shaandheeyo xogta Google Sheets ayaa adeegsanaysa shaqada FILTER .

Maqaalkan, waxaad ku baran doontaa sida loo isticmaalo labada hab.

Ku samee Arag Filter^{(Filter View)} xaashida Google

Habkan, waxaad ku baran doontaa sida loo isticmaalo filtar taasoo ku tusi doonta kaliya xogta kaydka xogta weyn ee aad rabto inaad aragto. Muuqaalkan shaandhaynta ayaa qarin doona dhammaan xogta kale. Waxa kale oo aad isku dari kartaa cabbirada shaandhada si aad u hesho aragtiyo shaandhayn oo aad u horumarsan sidoo kale.

Sida Loo Sameeyo Muuqaal Filter^{(How to Create a Filter View)}

Tusaale ahaan, qiyaas in aad haysatid xog xog ah oo ay ku jirto wax soo iibsiga ay macaamiishu sameeyeen. Xogta waxaa ku jira magacyo, cinwaano, iimaylo, lambaro telefoon, iyo in ka badan.

Tusaalahan, aan sheegno inaad rabto inaad aragto kaliya macaamiisha Playa Vista , CA, iyo macaamiisha kaliya ee leh ciwaanka iimaylka ".gov". 

1. Si aad u abuurto filtarkan, dooro Create a Filter icon ee menu-ka. Sumadani waxay u eegtahay madbakh. 

2. Waxaad arki doontaa calaamado shaandhooyin yaryar oo ka muuqda dhinaca midig ee madax kasta. Ka dooro summada godka sare ee goobta Ciwaanka Macmiilka^{(Customer Address)} si aad u habayso shaandhada goobtan. 

3. Tani waxay furi doontaa daaqad aad ku habeyn karto fursadaha shaandhada. Dooro falaarta dhanka bidix ee ku kala shaandhee qiyamka^{(Filter by values)} . Dooro Nadiif^(Clear) si aad u dooratid dhammaan gelinta goobtaas. 

Fiiro gaar^(Note) ah: Tani waa tallaabo muhiim ah sababtoo ah waxay dib u dejinaysaa aragtida muujinta dhammaan diiwaannada si ay u muujiso midna. Tani waxay u diyaarinaysaa Excel si ay u isticmaasho shaandhada aad abuuri doonto tillaabooyinka soo socda.

4. Ku qor qoraalka goobta hoose oo aad rabto inaad ku shaandhayso goobta. Tusaalahan, waxaan isticmaali doonaa "Playa Vista" oo aan dooran doonaa sumadda raadinta si aan u aragno kaliya diiwaanada qoraalkaas ku jira. Dooro^(Select) dhammaan diiwaanada ka muuqda liiska natiijooyinka. Tani waxay habaynaysaa filtarkaada si alaabta aad doorato oo kaliya lagu soo bandhigo xaashida xaashida.

4. Markaad doorato badhanka OK , waxaad arki doontaa xogta xaashidaada oo la shaandheeyay si macaamiisha Playa Vista kaliya loo soo bandhigo.

5. Si aad u shaandhayso garoon labaad, dooro astaanta shaandhada ee meesha ugu sareysa. Ku soo celi nidaamka kore si aad u abuurto shaandhada. Nadiifi dhammaan waxyaabaha la soo geliyay, ku qor qoraalka "gov" si aad u shaandheyso ciwaannada iimayl kasta ee aan ku jirin "gov", dooro gelintaas, oo dooro OK .

Hadda waxaad habaysay filtarkaaga si ay u soo baxaan kaliya diiwaannada ku jira kaydka xogta ee aad danayso. Si aadan ugu baahneen inaad ku soo celiso nidaamkan mar kasta oo aad furto xaashida faafinta, waa waqtigii la badbaadin lahaa shaandhada.

Kaydinta iyo Daawashada Muuqaalka Shaandhaynta^{(Saving and Viewing Filter Views)}

Markaad dhammayso dejinta shaandhadaada, waxaad u kaydin kartaa muuqaal filtar ahaan oo aad awood u yeelan karto wakhti kasta.

Si loo badbaadiyo aragtida shaandhada, kaliya dooro fallaadha hoos u dhaca ee ku xigta summada shaandhada oo dooro Keydi sida muuqaalka shaandhada^{(Save as filter view)} . 

Waxaad arki doontaa garoon madow oo cawl ah oo ka furan xagga sare ee xaashida. Tani waxay ku tusi doontaa kala duwanaanshaha la doortay ee shaandhadu khusayso iyo magaca goobta. Kaliya^(Just) dooro goobta ku xigta Magaca^(Name) oo ku qor magaca aad rabto inaad ka codsato shaandhadaas. 

Kaliya ku qor magaca oo tabo Gelida^(Enter) .

Waxaad ku ogaan doontaa dhinaca midig ee baarka cawl inuu jiro sumadda qalabka. Dooro summadan si aad u aragto xulashooyinka shaandhada. 

Ikhtiyaarada la heli karo waxaa ka mid ah:

• Magaca beddelka shaandhada
• Cusbooneysii inta kala duwan ee shaandheynta lagu dabaqo
• Ku koobbi filtarka si aad u cusboonaysiiso adoon saamaynayn filtarka asalka ah
• Tirtir filtarka 

Waxaad damin kartaa shaandhada aad karti u siisay mar kasta adigoo si fudud u dooranaya astaanta shaandhada.

Ogsoonow marka filtar kasta la furo, summada shaandhaynta ayaa cagaar noqon doonta. Markaad joojiso filtarrada, summadani waxay ku noqon doontaa madow. Tani waa hab degdeg ah oo lagu arko dhammaan xogta xogta ama haddii shaandhayn kasta uu xogta ka saaray aragtida hadda.

Ka dib, haddii aad rabto in aad dib u furto mid ka mid ah filtarrada aad abuurtay, kaliya dooro fallaadha hoos u dhaca ee ku xiga astaanta shaandhada. Waxaad arki doontaa filtarrada aad kaydisay oo ka muuqda liiska. Kaliya^(Just) door shaandhadaas si aad awood ugu yeelato mar kasta oo aad rabto.

Tani waxay shaandhayn doontaa aragtida mar kale iyadoo la isticmaalayo jaangooyooyinka filtarrada ee aad habaysay.

Isticmaalka Shaqada FILTER

Ikhtiyaar kale oo lagu sifeeyo Google Sheets waa isticmaalka FILTER function.

Shaqada FILTER waxay kuu ogolaanaysaa inaad shaandhayso xog-ururin ku salaysan tiro kasta oo shuruudo ah oo aad doorato. 

Aynu eegno adeegsiga FILTER -ka anagoo adeegsanayna tusaalaha Iibka Macmiilka^{(Customer Purchases)} ee qaybta u dambaysa.

Isku dhafka shaqada FILTER waa sida soo socota:

FILTER (kala duwan, xaalad1, [condition2, ...])^{(FILTER(range, condition1, [condition2, …]))}

Kaliya xadka iyo hal shuruud oo shaandhaynta ayaa loo baahan yahay. Waxaad ku dari kartaa inta badan shuruudaha dheeraadka ah ee aad rabto, laakiin looma baahna.

Halbeegyada shaqada FILTER^(FILTER) waa sida soo socota:

• kala duwan^(range) : Tirada unugyada^{(range of cells)} aad rabto in aad shaandhayso
• condition1 : Tiirka ama safafka aad rabto inaad isticmaasho si aad u shaandhayso natiijooyinka 
• conditionX : Tiirar kale ama saf oo aad sidoo kale jeclaan lahayd inaad isticmaasho si aad u shaandhayso natiijooyinka

Maskaxda ku hay in kala duwanaanta aad u isticmaashid xaaladahaaga waxay u baahan yihiin inay lahaadaan tiro la mid ah tirada safafka oo dhan.

Tusaale ahaan, haddii aad rabto inaad abuurto shaandhayn la mid ah qaybta hore ee maqaalkan, waxaad isticmaali lahayd shaqada FILTER^{(FILTER function)} ee soo socota .

=FILTER(F1:J20,SEARCH(“Playa Vista”,H1:H20),SEARCH(“gov”,I1:I20))

Tani waxay ka soo qaadanaysaa safafka iyo tiirarka shaxda xogta asalka ah (F1: J20 ) ka dibna waxay isticmaashaa shaqo SEARCH ku dhex jirta si ay u baadho ciwaanka iyo tiirarka iimaylka qaybaha qoraalka ee aanu xiisayno.

Shaqada SEARCH waxa kaliya oo loo baahan yahay haddii aad rabto inaad raadiso qayb qoraal ah. Haddii aad aad u xiisaynayso ciyaar sax ah, waxa kaliya oo aad u isticmaali kartaa tan sida bayaanka shuruuda beddelka:

I1:I20=”” [email protected]

Waxa kale oo aad isticmaali kartaa hawlwadeeno kale oo shuruudaysan, sida > ama < haddii aad rabto inaad shaandhayso qiimayaal ka weyn ama ka yar xadka go'an.

Markaad riixdo Gelida^(Enter) , waxaad arki doontaa natiijooyinka shaqada FILTER sida miiska natiijooyinka.

Sida aad arki karto, kaliya tiirarka tirada aad dooratay ee cabbirka koowaad ee shaqada ayaa la soo celiyaa. Markaa waa muhiim in shaqada FILTER la geliyo unug ay jirto qol (tiro ku filan) dhammaan natiijooyinka si ay u soo baxaan.

Isticmaalka Shaandhada Google-ka

Shaandhaynta xaashida Google^{(Google Sheets)} waa hab aad u awood badan oo lagu dhex qodo xog aad u badan oo^{(very large sets of data)} Google-ka ah^{(Google Sheets)} . Shaqada FILTER waxay ku siinaysaa dabacsanaan ku haynta xogta asalka ah ee meesha laakiin ka soo saarida natiijooyinka meelo kale.

Sifada shaandhaynta ku dhex jirta Google Sheets waxay kuu ogolaanaysaa inaad wax ka bedesho muuqaalka xog ururinta firfircoon si kasta oo aad u xiisaynayso wakhti kasta. Waad kaydin kartaa, kicin kartaa, bakhtiin kartaa, ama tirtiri kartaa filtarrada si kasta oo aad rabto.

Ma haysaa tabo xiiso leh oo aad ku bixinayso isticmaalka filtarrada Google^{(Google Sheets)} -ka ? La wadaag^(Share) kuwa qaybta faallooyinka ee hoose.

How to Filter in Google Sheets

When you’re wоrking wіth large datasets, it’s useful to know how to filter in Gоogle Sheets.

There are two ways to do this. You can use filter views in the Google Sheets menu, which lets you customize specific ways to filter the data in the sheet that you can reuse. A more dynamic method to filter data in Google Sheets is using the FILTER function.

In this article, you’ll learn how to use both methods.

Create a Filter View in Google Sheets

In this method, you’ll learn how to apply a filter that will show you only data from a large dataset that you want to see. This filter view will hide all other data. You can also combine filter parameters for more advanced filter views as well.

How to Create a Filter View

As an example, imagine you have a set of data that includes product purchases made by customers. The data includes names, addresses, emails, phone numbers, and more.

For this example, let’s say you want to see only customers from Playa Vista, CA, and only customers who have a “.gov” email address. 

1. To create this filter, select the Create a Filter icon in the menu. This icon looks like a funnel. 

2. You’ll see small filter icons appear on the right side of each column header. Select this funnel icon at the top of the Customer Address field to customize the filter for this field. 

3. This will open a window where you can customize the filter options. Select the arrow to the left of Filter by values. Select Clear to deselect all entries in that field. 

Note: This is an important step because it resets the view from showing all records to showing none. This prepares Excel to apply the filter you’re going to create in the next steps.

4. Type the text in the field below that you want to filter the field by. In this example, we’ll use “Playa Vista” and select the search icon to see only those records that contain that text. Select all of the records that show up in the results list. This customizes your filter so that only the items you select will be displayed in the spreadsheet.

4. Once you select the OK button, you’ll see the data in your sheet filtered so that only customers from Playa Vista are displayed.

5. To filter on a second field, select the filter icon at the top of that field. Repeat the process above to create the filter. Clear all entries, type the “gov” text to filter out any email addresses that don’t contain “gov,” select those entries, and select OK.

Now you’ve customized your filter so that only the records in the dataset you care about are displayed. So that you don’t have to repeat this process every time you open the spreadsheet, it’s time to save the filter.

Saving and Viewing Filter Views

When you’re done setting up your filter, you can save it as a filter view that you can enable at any time.

To save a filter view, just select the dropdown arrow next to the filter icon and select Save as filter view. 

You’ll see a dark gray field open at the top of the spreadsheet. This will show you the selected range that the filter applies to and the name of the field. Just select the field next to Name and type the name you’d like to apply to that filter. 

Just type the name and press Enter.

You’ll notice on the right side of the gray bar that there’s a gear icon. Select this icon to see filter options. 

Available options include:

• Rename the filter
• Update the range that the filter applies to
• Duplicate the filter to update it without affecting the original filter
• Delete the filter 

You can turn off the filter you’ve enabled at any point simply by selecting the filter icon again.

Note that when any filter is enabled, the filter icon will turn green. When you disable the filters, this icon will turn back to black. This is a quick way to see the entire dataset or if any filter has removed data from the current view.

Later, if you want to re-enable any of the filters you’ve created, just select the dropdown arrow next to the filter icon. You’ll see the filters you’ve saved appear in the menu. Just select that filter to enable it whenever you like.

This will filter the view again using the filter settings you’ve configured.

Using the FILTER Function

Another option to filter in Google Sheets is using the FILTER function.

The FILTER function lets you filter a dataset based on any number of conditions you choose. 

Let’s take a look at using the FILTER function using the same Customer Purchases example as the last section.

The syntax of the FILTER function is as follows:

FILTER(range, condition1, [condition2, …])

Only the range and one condition for filtering are required. You can add as many additional conditions as you like, but they aren’t required.

The parameters of the FILTER function are as follows:

• range: The range of cells you want to filter
• condition1: The column or rows that you want to use to filter results 
• conditionX: Other columns or rows you’d also like to use to filter results

Keep in mind that the range you use for your conditions needs to have the same number of rows as the entire range.

For example, if you want to create the same filter as the first part of this article, you’d use the following FILTER function.

=FILTER(F1:J20,SEARCH(“Playa Vista”,H1:H20),SEARCH(“gov”,I1:I20))

This grabs the rows and columns from the original table of data (F1:J20) and then uses an embedded SEARCH function to search the address and email columns for the text segments that we’re interested in.

The SEARCH function is only needed if you want to look for a text segment. If you’re more interested in an exact match, you can just use this as the condition statement instead:

I1:I20=”[email protected]”

You can also use other conditional operators, like > or < if you want to filter values greater than or less than a fixed limit.

Once you press Enter, you’ll see the results of the FILTER function as a results table.

As you can see, only the columns in the range you selected in the first parameter of the function are returned. So it’s important to place the FILTER function in a cell where there’s room (enough columns) for all of the results to appear.

Using Filters in Google Sheets

Filters in Google Sheets are a very powerful way to dig through very large sets of data in Google Sheets. The FILTER function gives you the flexibility of keeping the original dataset in place but outputting the results elsewhere.

The built-in filter feature in Google Sheets lets you modify the active dataset view in whatever way you’re interested at any given moment. You can save, activate, deactivate, or delete filters however you like.

Do you have any interesting tips to offer for using filters in Google Sheets? Share those in the comments section below.

Related posts

• Sida loo kala saaro ama loogu kala shaandheeyo Midabka Google-ka

• Sida Loo Isticmaalo Liisaska Hoos U Dhaca Google Sheets

• 9 Qodob oo Qarsoon oo ku jira Khariidadaha Google waa inaad hubisaa

• Waa maxay Google App-ka & Sida Loo Isticmaalo

• Sida Loo Geliyo Saxiixa Google Docs

• Sida Loo Isticmaalo Joogsiyo Badan Khariidadaha Google-ka

• Sida loola socdo isbeddelada Google Docs

• Waa maxay ilaalinta la xoojiyey ee Google Chrome ka iyo sida loo suurtogeliyo

• Waa maxay cabbirka iyo cabbirka Google Analytics?

• Waa maxay Khaladaadka "Taraafikada Aan Caadiga ahayn" Google iyo Sida loo Hagaajiyo

• Sida uu u shaqeeyo Google Drive Launcher Application

• Waa maxay Ogeysiiska Muujinta Google ee Ilaalinta COVID?

• Sida loo galo Inbox Zero gudaha Gmail

• Sida foomamka Google loogu dhex daro mareegahaaga

• Sida loo Demiyo oo loo Maamulo Ogeysiinta YouTube

• 8 Talooyin Raadinta Google: Had iyo jeer raadso waxaad raadineyso

• Sidee buu u shaqeeyaa Algorithm-ka YouTube?

• Google Hawshayda: Waa maxay sababta aad u daryeesho

• Waa maxay Qalabka Wariyaha Software-ka ee Chrome iyo sida loo joojiyo

• 20ka ugu Fiican ee lagu daro Gmailka iyo Kordhinta Isticmaalayaasha Awooda Iimaylka