Help with Ranking With Duplicates
$10-30 USD
Paguhet në dorëzim
I have a bunch of scores in J6:J17 and want to see Ranks in column K (best score gets highest rank (12). I have multiple duplicates among those scores, so using RANK won't work. I've tried SUMPRODUCT and COUNTIF and I feel as though I'm getting close.
There are 12 scores in a list. The highest of the scores should always get a rank of 12 (number of scores). The next highest should get an 11, and so on, so the lowest gets a rank of 1. However, if there are 2 identical scores in the series, they should receive the same rank - and the score below the duplicates would receive one rank below. So in a list of 12 scores with one set of duplicates, the lowest score would get a rank of 2. In a list of 12 scores with two sets of duplicates, the lowest score would get a rank of 3.
ID Projekti: #21339429
Rreth projektit
11 profesionistë freelancer dërguan një ofertë mesatare prej $19 për këtë punë
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.
$ 10 Only ------- In just 1 Hour ------- Excel VBA Macro & Formula Expert ------- 100% satisfaction first, then payment.
hi, my suggestion is doing this rating task with VBA due to your description. I have rich experience in excel (Advanced formulas, Charts, VBA, Macro,....), and I do my best to save your time and pocket. Please feel fre Më shumë
Hi, send the sheet. Am a professional accountant in KSA, who have 6+ years of experience. With high MS excel and financial management knowledge. I can provide you free samples with high quality and in a fair price. Ple Më shumë
Hi There, i am Experienced in Excel and related online works... Will give you Quality Work .. Kindly Discuss Further ...Thanks and regards (Najeeb)
Hello, I can help you with this excel project, and do the formulas wright and make it rank with duplicates (12-1). We can discuss more about this on chat. Thanks
I am a business graduate from LUMS, Pakistan. My daily work as a Commercial Analyst involves expert use of MS Office, specially MS Excel which is why I am very good at preparing financial models, and managing data. I a Më shumë
HI, I'm a Financial Analyst and MBA Graduate from NCBA&E Lahore with 6+ years of Experience in Finance & Excel Dashboard Reporting. I Can complete this task in few hours. Please contact me. Best Regards, Uzair Javed Më shumë
