Search

Filter Table

Last Updated: Dec 1, 2020

Articles

Use this function to filter the table using the specified column name and filter options.

Syntax

Filter Table (table_name, column_name, filter_options)

Parameters

Input Parameter Name Description
table_name Name of the table from table definition
column_name Column name to filter the table
filter_options Filter options to filter the table

Sample

Filter Table (Table1, A, pass)

  • Filters the column ‘A’ of the table ‘Table1’ based on the filter option ‘pass’.

To view all the Excel functions, click here.

Did you find what you were looking for?