Excel formula help - INDEX, MATCH, LARGE

$12-30 SGD

Completed

Posted

over 5 years ago

$12-30 SGD

Paid on delivery

Hi - I need some help building an excel formula that pulls fields based on multiple criteria into a dynamic list. I think the formula should be some combination of INDEX, MATCH, LARGE but am open to your solution. Target price is $20 SGD The criteria for the dynamic list is shown in C4:C12 of the attachment. The formulas for the dynamic list list should reference cells D4:D12 (not hard-coded) and show the information in the bottom half based on the Top 20 order of total price. I've made some of the cells in D4:D12 data validation lists to test that the dynamic list works. Also, if there are duplicate values for the total price, then the dynamic list should show all of them. For example, 5,000,0000 shows up many times. The dynamic list should each instance in the Top 20 if there are more than one.

Data Processing

Excel

Visual Basic

Project ID: 18406868

About the project

6 proposals

Remote project

Active 5 yrs ago

Looking to make some money?

Email address

Benefits of bidding on Freelancer

Set your budget and timeframe

Get paid for your work

Outline your proposal

It's free to sign up and bid on jobs

Awarded to:

@rinabuoy13

Hello, I am experienced excel expert. I can help with this task with quick turnaorund. Looking to hearing from you. Kind regards

$20 SGD in 1 day

5.0

(99 reviews)

6.2

6 freelancers are bidding on average $29 SGD for this job

@asadkhan3533

Please review my profile as i have relevant skills and experience required for this project. Kindly send me a message to discuss further. Thanks, Asad Khan

$30 SGD in 3 days

5.0

(178 reviews)

6.7

@usmanhassan123

Hello, Sir I have read your project description and I am 100% sure and confident about this project. I need little more discussion to make the things clear. I am a professional freelancer with more then seven years of experience. I already done many projects. Please come in inbox for further discussion. Thanks.

$51 SGD in 1 day

4.7

(79 reviews)

6.2

@mail2vimalarora

Hello, I am ready to discuss project with you. Being experienced in working on several excel projects related to forma/vba/functions etc. based on that I can quickly help you in getting your project done as you mentioned in the description. I am available to start now and want to discuss more specific details. Looking forward to have further project discussion on chat. Thanks. Vimal Arora

$20 SGD in 0 day