Excel formula help - INDEX, MATCH, LARGE

Končano Objavljeno pred 5 letoma/leti Plačilo ob prevzemu
Končano Plačilo ob prevzemu

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.

Obdelava podatkov Excel Visual Basic

ID projekta: #18406868

Več o projektu

6 predlogov Oddaljen projekt Aktiven pred 5 letoma/leti

Dodeljeno:

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 v 1 dnevu
(99 mnenj)
6.2

6 freelancerjev ponuja v povprečju za $29 na tem delu

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 v 3 dneh
(178 ocen)
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 Več

$51 SGD v 1 dnevu
(79 ocen)
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 men Več

$20 SGD v 0 dneh
(105 ocen)
5.9
pranthokumer

Hello there, I am highly interested to work on your project. I can do this with a good quality. Please send me message so we can discuss more. Thanks

$21 SGD v 2 dneh
(26 ocen)
4.4