In Progress

Excel formula help - change nested IF formula.

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.

Skills: Excel

See more: excel macro change cell contents, excel logo change, excel help label format, excel multiple functions in one cell, excel if between multiple ranges, if multiple results excel, multiple if statements in excel with text, excel if function multiple conditions, excel if statement multiple conditions range, nested if function meaning, nested if excel, cre template help change background, excel formula capture data time day, excel automatic change color depending value, need help change, excel help shift work, excel extension change dat, visual basic excel help replacing values, excel help clas, excel vba change pivot data sources

About the Employer:
( 2 reviews ) Singapore, Singapore

Project ID: #18408635

Awarded to:


Hi, I am an accountant and excel expert. I am having experienced in formula evaluation in excel so I would like to offer my proposal on your project Change nested IF formula. Please message me if you have any question More

$20 SGD in 1 day
(3 Reviews)

19 freelancers are bidding on average $27 for this job


I'd be happy to help you with this project. I'm experienced with all Excel functions including advanced formulas and macros and I have an excellent record of quick turnaround time. Just let me know when you're ready a More

$50 SGD in 1 day
(250 Reviews)

Pleasure to help you. Excel automation is my masterpiece in my accounting field. Feel free to message me to start the job. Thank you so much.

$20 SGD in 0 days
(70 Reviews)

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]

$30 SGD in 2 days
(71 Reviews)

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.

$40 SGD in 1 day
(18 Reviews)

It not the hard formula so I can give you a hand. Contact me if u want this. Veru fast solution will be given. Thank you.

$26 SGD in 1 day
(25 Reviews)

Good day, my name is William. I am an Excel specialist with 10 years of professional experience. I work as a Data Administrator and this type of work is very common. I can guarantee a quick turnaround. I have read yo More

$26 SGD in 1 day
(2 Reviews)

Hi there, I have 5+ years of experience in MS Excel and VBA programming. I could build the formula in 2 ways: 1- could give you the option to use wildcard (*) in any cell as you request. (e.g. use "FW3*" for "FW30" More

$20 SGD in 1 day
(4 Reviews)

Hello, ** do you like Pivottable? this process look easy in Pivottable! - Chat me to make a discussion of your project and send me more details to begin work. - I have good experience with Excel PivotTable, Dashboar More

$20 SGD in 1 day
(1 Review)

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.

$26 SGD in 2 days
(0 Reviews)

Ready to work on your problem. I am sure we can use references and lookup to recheck for repeated values.

$26 SGD in 2 days
(0 Reviews)

Here i am ready to do the projects and i am interested in article writing and excel work.

$24 SGD in 1 day
(0 Reviews)

I have good experience in excel

$12 SGD in 1 day
(0 Reviews)

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.

$16 SGD in 1 day
(0 Reviews)

I can do that task easily, I am a Microsoft Certified Specialist In Excel 2013 so it is going to be easy for me to do your work done ;)

$21 SGD in 3 days
(0 Reviews)

I’m a full time freelancer of data entry,To show clients that these are the services I provide and that I’m good at, I’ve uploaded one portfolio item. I am ready to give you hardworking, reliability, flexibility and h More

$27 SGD in 1 day
(0 Reviews)

Excel Relevant Skills and Experience Experience in excel

$27 SGD in 1 day
(0 Reviews)

Hello, Hope you are doing good and getting charged up for the Christmas carnival. Wish you a merry Christmas in advance. I have read your exact requirement that you are looking for an expert for excel formula for pull More

$50 SGD in 3 days
(0 Reviews)
$27 SGD in 1 day
(0 Reviews)