Excel: dynamic ranking

Hi there, the answer is easy, you need to use "weighing" to have what you desire. Let me help you in order to have a good and fast solution. I am here to help, best regards!

"""""""""""""""""""EXCEL EXPERT IS HERE""""""""""""""""""" "Sir, I am Excel Advanced Level Expert. This is basic work for me. I can complete this project with added quality. About me I am a Chartered Accountant with more than 4 years of experience from the worlds leading Accountancy and auditing firm ""PWC"". I can handle this task very efficiently and you can expect 100% accuracy from me. I am Microsoft Excel, accounting, auditing, financial statements, Form Creation in Excel through VBA and in Google Sheet, QuickBooks, and Sage expert. I have been working here from the last 1.5 year and I have 224+ 5 stars reviews here. I am not new to work. I know how to meet strict deadlines without compromising the quality of the work. I will also be available for any query after the job is done as I am building my clients. please be my client and get any type of accountancy, Excel, QuickBooks, and auditing-related work with quality, efficiency, and at reduced rates. Note. The price is negotiable. I will be available for any query round the clock even if the project is completed. Regards Arman Kakar

Hello, I will be glad to assist you with that. I am an advance level Excel expert holding years of experience in performing Data Analytics, Automation and various other calculations and analysis using VBA, Macro, Power Queries, Pivot Tables and Excel based formulas. Lets discuss your project in detail and how I am highly suitable for this.

Hello! I'm interested in your project. Your task is clear to me and I am ready to solve it. I have extensive and successful practical experience in processing and analyzing data in Excel, including using formulas.

Hello, I am an Excel expert. I understand your requirements to create dynamic formula to dynamically rank items based on calculation of both impact and complexity with priority to high impact and low complexity items. I can create the desired dynamic formula as per your requirement. Please check my reviews for quality of work and client satisfaction. Looking forward to working with you. Thanks, Hamid

I am expert in excel with 10+ years of experience , I understood the task completely and can do dynamic sorting/ranking of the items with the associated ranking number as desired , please share the excel file

Hello, I would suggest you use RANK formula with impact as the first condition and complexity as 2nd condition. This way, the impact will be the first priority (higher is better) If two rows have the same impact ==> which one has lower complexity score is better. Test data: ---------------------------------------------------------------------- Impact/Complexity/Score/Ranking 4 1 5 1 1 4 5 8 2 4 6 6 3 3 6 4 2 2 4 5 3 2 5 3 1 2 3 7 ---------------------------------------------------------------------- Regards, Nguyen

Hello there, just message me and ill send u working files even before awarding the project, i have a great experience in doing such formulas

Hi, Ready to change and set the formula for high priority as(highest impact with lowest complexity will be the highest rank)

Hello Sir, I have read your instructions and I can do it efficiently. Please give me this project. i will never disappoint you regarding your work and I will give you unlimited revisions with 100% quality work. Thanks. UMAIR

Hi, I understand the problem you are trying to solve and I can create the formula for you. This is really fun. Lets start. I can start right now and finish fast. Check my profile ( https://www.freelancer.com/u/infernalwrath ) for some of my previous works and client references. I will like to discuss the details with you.

Hello, We have been working on excel, vba, macros, finance for more than 9 years. We have more than 8 years of experience doing data based projects. I believe this is something I can for sure :) You may check the projects I have already completed here: https://www.freelancer.com/projects/excel/Excel-VBA-Data-Entry-Analysis-32285292/reviews https://www.freelancer.com/projects/excel/Data-Analytics-Project-30073140/details https://www.freelancer.com/projects/data-mining/DATA-MINING-ANALYSIS-USING-NEURAL/reviews https://www.freelancer.com/projects/excel/Hire-Excel-Expert-15193739 I would love to discuss the project further :). Best, Hem

Hello, This is well understood, and the function is ready within your attached sheet for your perusal. Please send me a reply if you would like to talk more. Kind Regards,

Hi There, Hope you are doing well, Interested in your posting as I’m used to performing such projects (See Profile). I can share the resolution right away for your review if you give me a chance. I would like to assist you at a reasonable price along with high-quality work delivered on time. Looking to hearing from you soon, Thanks & Regards, Leo,

Dear, I have reviewed your dynamic ranking requirements carfully and your need to not use VBA code, I believe I am your perfect candidate and it's my pleasure to apply and offer my services. I am a certified data analyst with 10 years of experience in automating tasks using Excel formulas. Also I am expert in data analysis tools Python, SQL, Excel, Access, Google Sheets, VB.Net, Tableau and PowerBI. Looking forward to your call to start working immediately. Yours A Dardear

Hello, there? I am Eduardo from Australia. I am happy to bid to your proposal. I have good knowledge in Excel. I can do the job without using vba, macro as your requirements. I hope you give me a chance to work with you. Best regards.

Hey! I am professional writer with the vast skills and qualifications necessary for this job. I have experience in Excel and Microsoft. I am confident that I can produce high-quality work that meets your specifications. If given the opportunity, I will exceed your expectations. I look forward to hearing from you. Please contact me to discuss more about this project. Thanks & regards Wilfred

Hello There I'm available and ready to start immediately, I'm a professional with microsoft Excel and using formual , and will help you to get an dynamic file . Here are some samples of my work, also kindly see more at the following link https://www.freelancer.com/u/rudina984 Kind Regards Rudina

Hey there!, My name is Akibul, and I was glad to see you are looking for an excel developer. I am planning to create a formula to get the dynamic ranking. Thanks!

My name is rohith I i think iam eligible for this work because I had learnt MS OFFICE very well and I have given many reviews of movies etc i think this helps me to do the work easy

Hello Mr, I am Md. ashadul islam. I am expert on excel data entry. If you want i will be done your job within very short time. Thank You very much