There are different ways Excel users can filter data when working with spreadsheets. One of the ways is greater than function. You can use different ways to filter in Excel greater than. Here, we discuss steps to follow when filtering in Excel greater than. Let’s get started.
Filter in Excel greater than a number using the sort and filter option
1. In an open Excel workbook, highlight the row you want to filter data on. It is good to select the header row or column when not dealing with specific cells alone.
2. Click Home section on the main menu ribbon.
3. Click the “Sort & Filter” option to display a drop-down list.
4. Select “Filter” from the list.
5. Afterward, you will notice a small triangle on the corner of the selected column
6. Click the small icon in the column to display a list. Click “Numbers Filters” on the list.
7. Select “Great Than.”
8. In the open “Custom AutoFilter” window, type your greater than the number.
9. Click the “OK”
using the FILTER function
If you are using Excel version 2021 or Microsoft 365, you can use the filter function to filter data in a range.
Excel’s filter function filters a range of data based on given criteria and gives results by extracting matching records.
Here, we use the formula below:
=FILTER (array, include, [if_empty])
Example
Let’s say you want to extract values from cells B2:B5 that are greater than 100. Your formula will be like this:
=FILTER (B2:B10, B2:B5>100)
If you want to extract in row B2:C5 where the values in B2:B5 is more than 100. You will use the formula:
=FITER (B2:C10, B2:B5>100)
Filter in Excel greater than using the Filter feature
1. Select any cell within the range that you want to be filtered.
2. Click on the Data tab on the main menu ribbon.
3. Under the Sort & Filter section, click on Filter. Doing so will highlight the column headers in your workbook.
4. Select a column header arrow.
5. Next, select Number Filters.
6. Afterward, select the option “Greater Than.”
7. Enter the filter criteria you are looking for and press the OK button
Using the Advanced Filter feature
1. Start by specifying the criteria. Do this by copying the headers and pasting them somewhere else in the worksheet.
2. Specify the criteria you want to filter the data. For example, you can specify you want to get records of sales of more than 1000 in a specific region.
3. In the Advanced Filter dialog box, here is what to do:
Action: select the option ‘Copy to another location.
List Range: select data that refers to the dataset from which you want to find your unique records.
Criteria Range: specify the criteria
Copy To: specify where you want your results displayed
Copy Unique Records Only: check the checkbox here.
4. Click OK.
Similar Reads
How to lowercase in Excel except for first letter: 6 easy ways