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.
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
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.
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