Need an Excel expert to help write formulas for spreadsheet

เสร็จสมบูรณ์ โพสต์แล้ว 5 ปีที่ผ่านมา ชำระเงินเมื่อจัดส่ง
เสร็จสมบูรณ์ ชำระเงินเมื่อจัดส่ง

I have a spreadsheet that I need to modify from another project. At present, the spreadsheet calculates the percentages of three values, ranks those values and then calculates and ranks those rankings. (IE: Value A, B, C; calculate difference between A & B and A & C, rank those calculations, then rank the rankings in a "Total Rank" column. This is done 2x, then another metric is added and a final rank is given. I need help writing formulas that filter out bad data (missing value and 0s) but still provide a final ranking.

Excel

หมายเลขโปรเจค: #16852753

เกี่ยวกับโปรเจกต์

42 ข้อเสนอ โปรเจกต์ระยะไกล ใช้งาน %project.latestActivity_relativeTime|แทนที่%

มอบให้กับ:

elqueabandona

Hello, my name is Cristian, I have a degree in Business and work with excel every day. I have much experience with spreadsheets, formulas, models and macros. Check my reviews. Best regards

$75 USD ใน 0 วัน
(300 รีวิว)
7.3

freelancer 42 คน กำลังเสนอราคาในงานนี้ โดยมีราคาเฉลี่ยอยู่ที่ $86

jaylancer43

Hello Sir, Thank you for this opportunity. My name is Jay and I'm an Expert Excel and VBA programmer on freelancer.com and have been featured by the freelancer community (https://www.freelancer.com/community/article เพิ่มเติม

$150 USD ใน 2 วัน
(817 รีวิว)
8.9
schoudhary1553

Hi there..... Warm Greetings We came along with your request for write formulas for spreadsheet and we reviewed your project description. We'd like to help you with confidence and satisfying results... We have เพิ่มเติม

$150 USD ใน 2 วัน
(399 รีวิว)
8.2
P0L

Hello, I’m an Excel expert and I would like to help you with your project. Please check my profile and contact me to discuss further details. Regards.

$75 USD ใน 1 วัน
(471 รีวิว)
8.0
zebracaro

I can do it for you quickly and exactly . Please contact me for saving your time and your money .

$70 USD ใน 3 วัน
(119 รีวิว)
7.1
dvcontact

Hi, Reading your project description about writing advanced Excel formulas that filter out bad data (missing value and 0s) but still provide a final ranking makes me feel like you have me in mind when creating the pro เพิ่มเติม

$100 USD ใน 3 วัน
(63 รีวิว)
6.9
RRconsultant

A proposal has not yet been provided

$100 USD ใน 3 วัน
(73 รีวิว)
7.1
khudammunir

Hi I would like to bid for this project. I posses Data Analytics, Research, Accountancy, Administration, Banking, Financial/Business Analysis & Reporting and Content Writing experience with Advance MS Excel Dashboards, เพิ่มเติม

$80 USD ใน 1 วัน
(36 รีวิว)
6.7
ShaunKleinOnline

Hi there, Your project sounds interesting and I think I would make a great fit. I have modeled complex RANK formulas with many different criteria which were utilized on various dashboards for multiple different busi เพิ่มเติม

$65 USD ใน 2 วัน
(93 รีวิว)
6.6
periyannas

Hi, Nice to know your requirement. I am an excel vba, vb6 expert and have delivered fourteen excel vba projects in the past seventy days. Willing to take up your project. Thank you, Regards.

$100 USD ใน 2 วัน
(164 รีวิว)
6.8
satishtl

- Can get the calculcations as specifiied and have rankings ranked per the Total Rank. - Have additional logic for the additional rank field and get the missing or bad values removed in the ranking process. - Have do เพิ่มเติม

$50 USD ใน 2 วัน
(49 รีวิว)
6.1
afenache

Hi, I have over five years experience in using Excel at an advanced level (formulas, array formulas, pivot table, macros, automatic calculation sheets) as an Industrial Engineer at Michelin. I am always keen to impro เพิ่มเติม

$100 USD ใน 2 วัน
(23 รีวิว)
5.7
Ashisjena2015

Hi, I will provide you instant help. Please discuss with me now over chat as I'm an advanced excel expert. Thank you!

$100 USD ใน 0 วัน
(41 รีวิว)
5.5
jasalaz100

Immediate availability. Responsible, fast and accurate. Full-time freelancer. Excel expert. 100% satisfaction guaranteed. Available to any help after completion. Experience of 7 years using excel for organizing เพิ่มเติม

$100 USD ใน 2 วัน
(31 รีวิว)
5.2
anetteu

Having worked as a management consultant for Deloitte, I have ample experience in manipulating and analyzing large data sets in order to extract relevant insights. I am detail-oriented and highly proficient at Mic เพิ่มเติม

$111 USD ใน 1 วัน
(12 รีวิว)
4.5
humayoonsheikh4u

A proposal has not yet been provided

$83 USD ใน 1 วัน
(12 รีวิว)
4.2
lherreraz

Hi there! I read the project's description and I'm sure that I can help you with this. I have a large experience working with advanced Excel, using formulas, functions and Macros using VB, the most important thing is t เพิ่มเติม

$50 USD ใน 1 วัน
(14 รีวิว)
3.6
caprateekr

Hi there, I am an excel expert with more than 7 years of experience in working with excel and using formula, message me so that we can discuss further in detail about your requirements. Thanks

$70 USD ใน 3 วัน
(14 รีวิว)
3.9
NarelleJ

Hi I am an Expert in Microsoft Excel, writing with formulas are my speciality. I look forward to working with you. Kind regards Narelle Relevant Skills and Experience Expert level excel Advanced use of formulas Dashbo เพิ่มเติม

$155 USD ใน 3 วัน
(4 รีวิว)
3.3
juvigy

Hi, The task is easy for me. Please attach a sample file and i can start working on it even if you don't select my offer. I can do it in 1 day. BR, Stoyan

$222 USD ใน 1 วัน
(6 รีวิว)
2.5
kitty120

Hello. I am glad to know you I read your project carefully and what I want is, I'll finish your project more perfectly. I have rich experience. I am exoert in excel. If you hire me, you'll get more than you think. เพิ่มเติม

$35 USD ใน 3 วัน
(1 รีวิว)
1.8