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 Nov 11, 2022
Preeti Bhardwaj
from Hubei, China

Skills & Expertise Required

Data Analysis Microsoft Excel Statistics

Open for hiringApply before - Nov 15, 2024

Work from Anywhere

40 hrs / week

Fixed Type

Remote Job

$38.34

Cost

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

Website Redesign (Using SquareSpace Platform) - Fixed
J2EE Developer - Fixed
Research paper - Fixed
Logo Design Needed for food company - Fixed
Back-End Development - Fixed
Design poster - Fixed
Update front end for data entry page to make it user friendly - Hourly
Ad hoc Business Development/Sales representative needed - Hourly
Social Networking Site. Need fixing. - Fixed
Software Engineer - Hourly
Traffic platform needed! Long term job. - Fixed
Recording setup - Hourly
Industrial Designer - Hourly
App developer - Fixed
Need Connection Built Between Infusionsoft and Amazon SES - Hourly
Court Reporter/Notary . - Hourly
Seeking a full stack NLP developer - Fixed
3D Modeling and Rendering - Fixed
IT JOBS - Hourly

Similar Projects

Contact information collection

Looking for a freelancer to find the Youtuber contacts information based on the list of the link we gave. Need someone who is professional to look for correct information and be able to finish the job in a short time.

Social Listening and Analytics Report for Facebook Page

I have a current client that would need social listening. They basically want a report where they can get an advantage over competitors and how we can be better to stay ahead of the competitors. Need someone to analyze these data, KPIs needed, recomm...read more

Data / Developer (API's, Data Structures and Data manipulation)

Role Overview

Maths background with interest in computing, Bayesian analysis with
ability to understand machine-learning, data mining, and information
retrieval to design, prototyping, and aide in developing next-generation analytic...read more

trading platform

I have MT4 EA Alphameteix Renko, MA and TDI indicator.

- Requirement is to develop API , which can be integrated with Trading Platform to execute Buy, Sell and Closing Of ( Square Off ) the trades upon pre defined conditions are complied wit...read more

Google Sheets Stock Comparison

Hello! I am seeking a programmer who will be able to use google sheets to help auto populate a personal Stock Analysis sheet with information found from
Stock Exchange, 10K statements, Financial Reports, etc.

Foe example, we are lookin...read more