Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Table Filter
defaultDoe|Fry
cell-width
userfilterLast Name
datepatternyy-mm-dd
id14576941379421457694292173_-159727723997170632
separatorPoint (.)

Last Name

First Name

Occupation

City

Doe

John

Developer

London

Fry

Philip

Delivery boy

New York City

Doe

Janet

Scientist

Tokyo

Farnsworth

Hubert

Scientist

New York City

Farnsworth

Cubert

Student

New York City

Table Filter
defaultDoe, London
cell-width,
columnLast Name, City
datepatternyy-mm-dd
id14576941379431457694296418_-159727723997170632
separatorPoint (.)

Last Name

First Name

Occupation

City

Doe

John

Developer

London

Fry

Philip

Delivery boy

New York City

Doe

Janet

Scientist

Tokyo

Farnsworth

Hubert

Scientist

New York City

Farnsworth

Cubert

Student

New York City

Table filtration by the user-entered keyword

Info

Please note that Table Filter macro allows you to add free-text fields for dynamic data filtration depending on the specified query.

Try to start entering some values for filters to get dynamic filtration of the table.

Table Filter
default,,,
cell-width,,,
userfilterFirst Name,City,Last Name,Occupation
datepatternyy-mm-dd
id1457694300404_1866020122
separatorPoint (.)1457694137943_-159727723

Last Name

First Name

Occupation

City

Doe

John

Developer

London

Fry

Philip

Delivery boy

New York City

Doe

Janet

Scientist

Tokyo

Farnsworth

Hubert

Scientist

New York City

Farnsworth

Cubert

Student

New York City

Global filter

Info

The global filter allows you to dynamically filter values in all columns of your table. Enter some query to get the table filtered.

Table Filter
default
cell-width
datepatternyy-mm-dd
globalFiltertrue
id1457694304175_1866020122
separatorPoint (.)1457694137943_-159727723

Last Name

First Name

Occupation

City

Doe

John

Developer

London

Fry

Philip

Delivery boy

New York City

Doe

Janet

Scientist

Tokyo

Farnsworth

Hubert

Scientist

New York City

Farnsworth

Cubert

Student

New York City

Filtering multiple tables at once

Info

You can filter several tables at a time. Just paste two or more tables into the macro.

Table Filter
default,,
cell-width100,150,200
columnLast Name,First Name,Occupation
datepatternyy-mm-dd
id14576941379431457694308097_-1597277231576072861
separatorPoint (.)

Last Name

First Name

Occupation

City

Doe

John

Developer

London

Fry

Philip

Delivery boy

New York City

Doe

Janet

Scientist

Tokyo

Farnsworth

Hubert

Scientist

New York City

Farnsworth

Cubert

Student

New York City

Last Name

First Name

Occupation

City

Brown

Adam

Developer

New York City

Fry

Andy

Delivery boy

London

Black

Jane

Scientist

Tokyo

McCarthy

Hubert

Scientist

New York City

McCarthy

Cubert

Student

London

...