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
Hemang Dutia
from Ohio, United States

Skills & Expertise Required

Data Analysis Microsoft Excel Statistics

Open for hiringApply before - Dec 3, 2024

Work from Anywhere

40 hrs / week

Fixed Type

Remote Job

$38.11

Cost

Offer to work on this project closes in 60 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

Convert file to PDF - Fixed
Vinylstormco graphic designer - Hourly
Very Simple Logo - Hourly
O365 Consultant - Hourly
Need Hedge Fund Associates/Advisors (Legal) - Hourly
Need a front-end and back-end developer to rewrite an iOS application - Hourly
Tax Planning and Advisor - Hourly
LAUNCH/MARKETING - Hourly

Similar Projects

Church List

I need an Excel spreadsheet listings g all of the Christian churches in Brooklyn and Queens. I would need:

1. Name of the Church
2. Name of the Pastor of the Church
3. Phone number of the church
4. Mailing address of the churchread more

Convert our excel workout program into an interactive locked data sheet

We have an excel sheet from a world reknowned weight lifter and professional powerlifter that we would like to productize and sell as a info product.

In doing so, we need to convert the excel sheet into either an interactive PDF or interact...read more

Develop script in excel to pull data from websites

I am looking for someone to develop a script to pull data from Baltimore Citys Violation Website. Once on the website, you select the 2nd box next to neighborhood corresponding with the neighborhood in Column A(spreadsheet attached). After you selec...read more

R Econometrics

Im looking for someone for a series of econometrics jobs using recent r packages which was experience using SVARs,SVECs etc.

Data Scientist Needed

Were looking for someone to gather multiple data points regarding different real estate markets. If you have experience in collecting data such market growth per zip codes, population growth per zip code, sales per zip code, etc. please reach out. *...read more