Hi - I need some help building an excel formula that pulls fields based on multiple criteria into a dynamic list. Another freelancer was able to develop one using Nested Ifs but I'm unable to use the * wildcard with If statements. This is a critical requirement and Iam open to your solution. Target price is $20 SGD
The work done by the previous freelancer is attached. 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.
19 freelancers are bidding on average $27 for this job
I am an Excel and VBA specialist with a lot of experience in creating complex formulas and macros. You may check some of my projects here: [login to view URL]
Hello sir, I have 4+ years of experience . I got your points. I can work for you. So please share more details about your requirements. So please contact me. Tell me your quote what should you prefer.
I am software engineering student now I am expert in ms office, c programming and java. I can do these task easily. I want to built my [login to view URL] will be happy with my work. thanks.
expert in programing & database. Teaching ICDL courses and implimentation Get ready for an acquaintance through this excel project. Relevant Skills and Experience Best solution and quality in the shortest time.