+ Reply to Thread
Results 1 to 3 of 3

Help with Equation for ranking weekly winners

  1. #1
    Registered User
    Join Date
    01-05-2021
    Location
    Maryland
    MS-Off Ver
    Office365
    Posts
    2

    Question Help with Equation for ranking weekly winners

    I have created a spreadsheet for a weightloss contest between myself and two of my friends. I've looked at some of the other examples here, but the formatting is different enough that I have been having trouble figuring this out and would appreciate help from someone more experienced with Excel (I play with coding in my spare time, but have no background beyond C++ classes I took 20 years ago).

    Originally, the contest was only with one other person, head to head on a weekly basis. Each week, we would weigh in on a Friday morning and input our weight for the week. The spreadsheet would then calculate our weekly percentage change, relative to our previous week's weigh in, and compare our percentages to determine the winner. I used the following formula:

    = if(F21=N21, 0, if(F21>N21, 20, -20))

    My weight loss percentage is in column F, where my friend's is in column N. This nested if statement worked really well when it was just the two of us. I also have another cell giving us a running total of what we owe each other. If we tied in a given week, neither person won.

    We are adding a 3rd friend to our contest, and I am struggling with how to compare all 3 sets of numbers, and give output based on the comparison.

    By way of example, my goal would be to compare the value from cell F21, N21, and W21. If a given participant has the highest value, then I want to output +30, if the middle -10, and if the least lost, -20.

    In this way, the winner will be assigned 30 each week, with 2nd and 3rd place chipping in different amounts based on their rankings. If possible, I'd also like to conditionally format the cells to display different colors based on the weekly outcome (ie. +30 = Green, -10 = Yellow, -20 = Red), but that is secondary to having the amounts automatically compared and payouts listed in a column. If you have any suggestions or resources, I'd appreciate it!

  2. #2
    Valued Forum Contributor
    Join Date
    01-16-2012
    Location
    England
    MS-Off Ver
    MS 365
    Posts
    1,391

    Re: Help with Equation for ranking weekly winners

    It would be easier to help if you upload a small sample worksheet showing the layout with the three of you in it, and include where the "financials" are entered?

    Ochimus

  3. #3
    Registered User
    Join Date
    01-05-2021
    Location
    Maryland
    MS-Off Ver
    Office365
    Posts
    2

    Re: Help with Equation for ranking weekly winners

    Ochimus,

    Got it. Thanks you for the reply! I'll try to upload something tonight. Appreciate it!

    PCN

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. How to display tie winners?
    By TXT007 in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 12-17-2019, 10:02 PM
  2. [SOLVED] picking out two winners
    By Tresfjording in forum Excel Formulas & Functions
    Replies: 28
    Last Post: 09-02-2018, 09:19 AM
  3. Replies: 1
    Last Post: 07-02-2015, 06:57 PM
  4. Replies: 2
    Last Post: 06-28-2015, 03:09 AM
  5. Help - Count Top 10 Winners
    By tyleromaha in forum Excel Charting & Pivots
    Replies: 11
    Last Post: 08-09-2012, 02:21 PM
  6. Weekly Sum Equation Needed
    By neelpatel in forum Excel General
    Replies: 5
    Last Post: 07-27-2012, 04:08 PM
  7. no duplicate winners
    By gricardo in forum Excel General
    Replies: 1
    Last Post: 02-22-2009, 03:12 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1