Filter

The Filter function is a feature that allows you to refine and display data from a specified range based on criteria you define.

See it in Action

Requirements

Data

• Target Data

  • Data Range: Identify the data range where you want to apply the function.

• Criterion: To tailor the displayed data, you can establish multiple filtering criteria. For each criterion, include:

  • Column: Specify the column in your data range that the criterion applies to.

  • Operator: Choose an operation that defines the relationship between the data and your criterion. Options include "==", "!=", ">=", "<=", ">", "<" for direct comparisons; "empty" or "not empty" for checking cell content; and "include" or "not include" for finding text within cells.

  • Value: Enter the value to be compared against the data in the specified column.

Fill empty cells with

• Keep Empty: Leave cells that are empty as is, without adding any text.

• Forward Fill: Copy the value from the nearest non-empty cell above into empty cells before adding the specified letters or text.

• Backward Fill: Copy the value from the nearest non-empty cell below into empty cells before adding the specified letters or text.

• -: Fill empty cells with a letter "-".

• 0: Fill empty cells with a letter "0".

• Custom: Allows for a custom value or text to be inserted into empty cells prior to adding the specified letters.

Result Destination

Specify the starting cell where the results will be placed.