Excel formula help - INDEX, MATCH, LARGE
$12-30 SGD
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.
ID projekta: #18406868
Več o projektu
Dodeljeno:
Hello, I am experienced excel expert. I can help with this task with quick turnaorund. Looking to hearing from you. Kind regards
6 freelancerjev ponuja v povprečju za $29 na tem delu
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 Več
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č
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