Remote Data Mining And Management Job In Data Science And Analytics

Advanced Excel - INDEX and MATCH with multiple criteria with incremental match return

Find more Data Mining And Management remote jobs posted recently Worldwide

To all the excel experts out there, I need help on an advanced formula. I am trying to use an INDEX MATCH formula that is configured with MATCH set to look through a one-column range and provide a match based on given criteria. The sample criteria looks at Category A and Category B, then assigns the group number through the predefined index table.

This formula uses boolean logic to create an array of ones and zeros to represent rows matching both criteria, then uses MATCH to match the first 1 found. This is a LIMITATION as I need the matches to return subsequent Groups. I will share some illustration file with shortlisted candidates. Please help!

I was able to get the first index match, through the tutorial from exceljet.

But, its only returning the first criteria row value that matches. Not results of the subsequent matches.
About the recuiter
Member since Mar 14, 2020
Vishwas Educati
from Gabrovo, Bulgaria

Skills & Expertise Required

Data Analysis Microsoft Excel Statistics

Open for hiringApply before - Jul 13, 2024

Work from Anywhere

40 hrs / week

Fixed Type

Remote Job

$38.36

Cost

Offer to work on this project closes in 12 days!
Are you interested in this Opportunity?

Looking for help? Checkout our video tutorial
How to search and apply for jobs

How to apply? Do you have more questions about the Job?
See frequently asked questions

Other jobs by this client

Modifications needed to custom photo delivery/payment system - Fixed
Cloud Integration Specilaist needed . - Fixed
Office administrator - Hourly
Website Developer needed to create modern & responsive Shopify Website - Fixed
3d case design for iPhone X and iPhone 8 - Hourly
Ongoing Design and Development Wordpress sites - Hourly
Google ad campaign - Fixed
Develop custom woocommerce payment plugin - Fixed
MicroStrategy Connection from Apache Spark - Hourly
Cad - Hourly

Similar Projects

Need Customer Service Email Agent + For Other Tasks

I am looking for someone to hire who can be customer service and who can fulfill orders. The scope of the job may increase but for now, it will be customer service. The job will start with only a few hours a week but will increase as time goes on.

Mailing addresses from Word into Excel (template provided)

Mailing addresses currently in WORD format, need to be converted (moved, copied or re-typed) to Excel format (template will be provided). Roughly 150 - 175 addresses

If possible, this needs to be completed asap (today) - please specify how l...read more

Convert PDF Document to Word Document

I have PDFs of scanned documents that needs to be converted to Word documents. The PDFs use different fonts, font sizes and format. Theres tables and charts with different line styles. All these must be changed to a consistent table style and format...read more

Natural Products Exibition 500 Company Data Collection

I need to collect data from Natural Products Expo West 2020.There is a list of companies you can collect from google research or you can use a android apps name Natural products Expo. I will send a excel file with example. I need Company name, Pers...read more