I gang

Advanced Filtering tool for Excel

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.

B) In case of exact match, the word "car" will only filter lines within value "car"

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!

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

Se mere: excel vba filtering sheet, filtering outsourcing excel, excel macro filtering, advanced excel pivot filtering, virtuemart year model engine brand filtering tool, filtering data excel, filtering done excel, excel data filtering, excel advance filtering, excel vba filtering data, sorting and filtering in excel 2013, what is sorting and filtering in excel, filtering in excel, sorting and filtering in excel 2007, how to speed up filtering in excel, advantages of sorting and filtering in excel, sorting and filtering in excel, excel not filtering entire column, conditional sorting and filtering in excel, advanced sorting and filtering in excel

Om arbejdsgiveren:
( 1 bedømmelse ) Belém, Brazil

Projekt ID: #29879348

Tildelt til:

SpotContent

Hello Sir, I am a software engineer and a professional content writer geared up with 8 years of experience under numerous niches. My writing umbrellas seo articles, blogs, academic writing, case studies and much more. Flere

$35 USD på 1 dag
(7 bedømmelser)
2.8

5 freelancere byder i gennemsnit $36 timen for dette job

BAVarun

**** have mac with big SUR OS ****** Expert in excel with over 15+ years of experience and over 4.9 user rating on this platform. Completed over 61 projects on FL. Expertise in - • Macros • Formulae • VBA • Flere

$50 USD in 7 dage
(56 bedømmelser)
5.3
Monirulop

Hi, I am ready to start right now. I can help you with your project according to your requirements. I am interested in your project. I ensure I will complete the task successfully and within the specified time. I love Flere

$66 USD på 1 dag
(23 bedømmelser)
4.0
rajnigodara

Hi there. I can help you to complete task in a short time. Please get in touch so that we can discuss further. Looking forward to hearing from you. Thanks. Rajni Godara

$15 USD in 2 dage
(10 bedømmelser)
3.5
smadan2k

Hi there, I am a Commerce Graduate with working experience of 20+ years in data entry, marketing and customer service, Accounting software, etc. I had worked for NGOs and also worked in different industries like Electr Flere

$15 USD in 3 dage
(0 bedømmelser)
0.0