Lengkap

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:

Equals...

Does not equal...

Begins with...

Ends with...

Contains...

Does not contains

Greater than...

Greater than or Equals to...

Less than or equals to....

Between...

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;

etc.

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.

OBS:

- 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)

Thanks!

Kemahiran: Excel, PHP, Visual Basic, Pemasukan Data, Excel VBA

Lihat lagi: 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?

Tentang Majikan:
( 3 ulasan ) Belém, Brazil

ID Projek: #29871842

Dianugerahkan kepada:

jiansevillejo

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 dalam 7 hari
(13 Ulasan)
3.1

7 pekerja bebas membida secara purata $29 untuk pekerjaan ini

(46 Ulasan)
4.5
(18 Ulasan)
4.3
Sunitav36

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 Lagi

$40 USD dalam sehari
(17 Ulasan)
3.5
Wanngming

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 Lagi

$30 USD dalam sehari
(4 Ulasan)
2.5
mna9226

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 Lagi

$30 USD dalam 2 hari
(2 Ulasan)
0.5
marianassemaziz

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 Lagi

$10 USD dalam sehari
(0 Ulasan)
0.9