How to extract Values ​​greater or smaller than a certain number

We can extract Values ​​greater or smaller than a certain number. For example, in the table above, we want to know Who is taller than 201? FILTER function The FILTER function is one of the Lookup & reference functions of Excel. It extracts all record from the database that matches the specified conditions. FILTER Arguments  FILTER(array, include, [if_empty]) FILTER function has 3 […]

How to filter multiple criteria in Excel

We can filter multiple criteria in Excel in different ways: logical AND operator : In this case, we use the multiplication operator (*) to return all the values ​​in the range of our array. logical OR operator : In this case, we use the multiplication operator (+) to return all the values ​​in the range of our array. FILTER function The FILTER function […]

How to Count specific words in a range

In the following example, as you can see in the photo, Count specific words in a range can be identified by the EXACT and SUMPRODUCT functions. EXACT function The EXACT function is one of the TEXT functions of Excel. It checks whether two text strings are exactly the same, and returns TRUE or FALSE. EXACT is case-sensitive. EXACT arguments […]