Native excel table filter with multiple values

I need someone to make the excel table filtering tool (located in the header of each column of tables - [login to view URL]) be able to work with multiple values.

The value(s) to be filtered needs to be set up into a separated table, one per row.

The filter to be developed needs to offer the following conditions options:


Does not equal...

Begins with...

Ends with...


Does not contains

Greater than...

Greater than or Equals to...

Less than or equals to....


Not between...

Each one of these condition has the same logic as the related options offered by native excel filter tool.

The behavior of table, when applying the filter, must be the same as when using the native excel filter. In other words:

1 - Results must be filtered inside the original table;

2 - There must be an option to clear the filter;


There are only two differences to be made between the filter to be developed and the native filter of excel:

1 - Needs to accept multiple values, defined one per line in a separated table

2 - There should be an option or mechanism to set if matching should be trigged by partial match or exact match.

For example:

A) In case of partial match, the word "car" will match lines within values like: car, cars, carrousel, etc., for example: "cars", "my car", , "my cars", etc (for "contains" logic)

B) In case of exact match, the word "car" will only filter lines within value "car", for example: "car", "my car", etc (for "contains" logic)

Just to understand the purpose of the project:

I will filter the table, analyze the results, change or add some cell values/lines/columns of the table. Then, i will clear the filter. After that, all results should be back again, keeping any modifications made. Then, i will repeat the process several times.


- Cell values, as well as quantity of rows and columns of the table to be filtered are variable. The developer of this project needs to create a filter system that works with any table. The values of the filter are variable as well;

- Needs to work with Excel for MAC (OS: Big Sur)


Evner: Excel, PHP, Visual Basic, Dataindførsel, Excel VBA

Se mere: excel count rows multiple values cell, jquery filter multiple values table, excel vlookup return multiple values vertically, excel vba filter multiple criteria, angularjs filter multiple values, rest api filter multiple values, excel text filter multiple words, excel fill down multiple values, excel vba find multiple values in range, jquery table filter multiple criteria, excel macro filter multiple criteria, excel vba filter multiple criteria different column, excel filter multiple values in one column, excel filter multiple values in one cell, excel filter multiple values, sharepoint list view filter multiple values, pivot table filter column values, pivot table filter multiple columns, excel vba filter multiple criteria same column, how do i filter multiple values in one column in excel?

Om arbejdsgiveren:
( 3 bedømmelser ) Belém, Brazil

Projekt ID: #29871842

Tildelt til:


Hi, I can help you with your file. I have advanced knowledge of Excel's formulas, pivot tables, charts and visual basic coding. I'm willing to discuss more about your project.

$35 USD in 7 dage
(13 bedømmelser)

7 freelancere byder i gennemsnit $29 timen for dette job

(46 bedømmelser)
(18 bedømmelser)

Hi Sir, i have Checked the Project: Native excel table filter with multiple values I carefully read your project description & I can handle this in my best care and professional manner. Please message me to discuss t Flere

$40 USD på 1 dag
(17 bedømmelser)

Hi, bro! I have read your requirement and I noticed that I am appropriate to this project. I have rich experience with data processing using Excel table and VBA. Everyone call me a "Prince of Excel". I promise I will f Flere

$30 USD på 1 dag
(4 bedømmelser)

Hello, Please review my profile as I have the relevant skills and experience required for this project. I can start working right now. Kindly send me a message to discuss further for references, portfolio, and case Flere

$30 USD in 2 dage
(2 bedømmelser)

Hello, Having read your project & fully understood your project needs. i`m so excites to start in your project right now. given that i ve 10 years experience with excel, especially with advanced filter tables very fa Flere

$10 USD på 1 dag
(0 bedømmelser)