+ Reply to Thread
Results 1 to 5 of 5

Help me create a formula to give "chances" to win

  1. #1
    Registered User
    Join Date
    05-04-2011
    Location
    North Loup, Nebraska, USA
    MS-Off Ver
    Excel 2010
    Posts
    7

    Smile Help me create a formula to give "chances" to win

    Greetings! I have a different one for you, but it seems the questions I ask on this forum are always different!

    Our group is holding a fundraiser. For the different amounts sent in, there are "chances to win" one of ten cash prizes.


    Amount.....Chances
    $25...........1
    $50...........2
    $100.........5
    $200........10
    $300........15
    $500........25
    $750........40
    $1000......55

    We are creating a file of donors, and I would like to make a separate sheet on our document that would populate the donors name a set number of times, depending on the amount. Example: Jim donated $100, and his name will be listed five times.
    Example 2: Phylis and Jim donated $1000 and the name will be listed 55 times. (see sheet 2 on the attached file for examples)

    My end goal will be to cut these names apart for our drawing, but it's becoming tedious and we're only at the beginning of our donor list!

    I don't care which direction or anything like that; I was just hoping this was up someone's alley!

    Thanks for considering this problem. (And what an awesome problem, that we have folks willing to donate during this time! I do NOT want to complain over a computer task!) I'm also open to any suggestions/alternatives to this issue!
    Attached Files Attached Files

  2. #2
    Valued Forum Contributor
    Join Date
    04-24-2020
    Location
    Woodbridge, VA
    MS-Off Ver
    2016
    Posts
    434

    Re: Help me create a formula to give "chances" to win

    Edited:

    Hi
    I do not see anything on Sheet 2 of your attached file.

    Are you wanting to do a live drawing (like where you pick names out of a hat) or do you want Excel to randomly pick the winners for you.

    If you want Excel to pick the winner, I would suggest instead of the amount they donated, but the number of times they donated in a separate lines and give a number to them.

    For example
    1. Trotters
    2. Trotters
    3. Trotters
    4. Trotters
    5. Trotters
    6. Bill and Earlen

    Then use like a random function where it will pick the number for the winner. I found link below that can walk you through it.

    https://www.youtube.com/watch?v=YamE4KqCv3k


    If that's not what you're looking for, let me know then I can figure something else out.
    Last edited by mikeava; 10-01-2020 at 07:08 PM.

  3. #3
    Registered User
    Join Date
    05-04-2011
    Location
    North Loup, Nebraska, USA
    MS-Off Ver
    Excel 2010
    Posts
    7

    Re: Help me create a formula to give "chances" to win

    Hello, and thanks for the message!

    I've reattached a file...hopefully my examples are on there. However, your ideas for a random pick would definitely work (and save me finding a really big hat to put the names into)!

    I'll check out the video you linked.
    Attached Files Attached Files

  4. #4
    Registered User
    Join Date
    05-04-2011
    Location
    North Loup, Nebraska, USA
    MS-Off Ver
    Excel 2010
    Posts
    7

    Re: Help me create a formula to give "chances" to win

    Mikeava-

    Yes- I definitely want to pick using that formula. Thanks for the video suggestion!

    Any idea on how to populate those names 5 or 55 times?!

  5. #5
    Forum Expert wk9128's Avatar
    Join Date
    08-15-2020
    Location
    China Shanghai
    MS-Off Ver
    365 V2402 and WPS V2022
    Posts
    3,318

    Re: Help me create a formula to give "chances" to win

    worksheet name : Sheet2 , A1 cell formula copy drag down and accross

    HTML Code: 
    Just Ref Sheet1 , I2 cell ,copy down
    =REPT($A2,LOOKUP($B2,{0,25,50,100,200,300,500,750,1000},{0,1,2,5,10,15,25,40,55}))
    Last edited by wk9128; 10-01-2020 at 09:56 PM.

+ 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. Replies: 3
    Last Post: 10-22-2019, 08:34 AM
  2. Replies: 3
    Last Post: 07-07-2018, 01:12 AM
  3. Replies: 4
    Last Post: 03-11-2015, 10:05 AM
  4. Replies: 1
    Last Post: 08-15-2014, 06:00 AM
  5. Replies: 5
    Last Post: 10-12-2010, 06:46 AM
  6. Compare four columns, give "yes" or "no" answer
    By LaurenR in forum Excel General
    Replies: 8
    Last Post: 09-17-2009, 03:52 PM
  7. [SOLVED] create links to check boxes marked "good" fair"and "bad"
    By pjb in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 04-19-2006, 09:25 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