/docs/community?hl=en

how can i make a weighted random number generator for raffle?

1

Hi there,

I am trying to create a raffle in sheets but no luck so far. I have about 100 people in the raffle, all with multiple entries ranging from 1-5 or so. My data currently looks like this:

Column B: Names of participants
Column D: Number of entries

I would like to create a function that helps pick a winner for 5 different prizes, with no participant being able to win more than once.

I hope something like this is possible. Let me know if any additional information is helpful. I am new to this.

Thanks in advance.

Latest Update Latest Updates (0)

Relevant Answer Relevant Answers (0)

Our automated system analyzes the replies to choose the one that's most likely to answer the question.

This question is locked and replying has been disabled.

Discard post? You will lose what you have written so far.

Failed to attach file, click here to try again.

Edit link

Notifications are currently off and you won't receive updates. To turn them on, go toNotifications preferences on your Profile  page.

Discard post?

You will lose what you have written so far.

Personal information found

We found the following personal information in your message:

This information will be visible to anyone who visits or subscribes to notifications for this post. Are you sure you want to continue?

A problem occurred. Please try again.

Create Reply

Edit Reply

This will remove the reply from the Answers section.

Notifications are off

Your notifications are currently off and you won't receive subscription updates. To turn them on, go to Notifications preferences on your Profile page.

Google user

This reply is no longer available.

Badges

Some community members might have badges that indicate their identity or level of participation in a community.

Google Employee — Google product team members and community managers

Community Specialist — Google partners who help ensure the quality of community content

Diamond Product Expert — Community members with product mastery who help other Google users and Product Experts

Platinum Product Expert — Community members with advanced product knowledge who help other Google users and Product Experts

Gold Product Expert — Community members with in-depth product knowledge who help other Google users by answering questions

Silver Product Expert — Community members with intermediate product knowledge who help other Google users by answering questions

Product Expert Alumni — Former Product Experts who are no longer members of the program

Community content may not be verified or up-to-date.

/docs/threads

//accounts.google.com/ServiceLogin

You'll receive email notifications for new posts at

Unable to delete question.

Unable to update vote.

Unable to update subscription.

You have been unsubscribed

Deleted

Unable to delete reply.

Removed from Answers

Removed from Updates

Marked as Recommended Answer

Marked as Update

Removed recommendation

Undo

Unable to update reply.

Unable to update vote.

Thank you. Your response was recorded.

Unable to undo vote.

Thank you. This reply will now display in the answers section.

Link copied

Locked

Unlocked

Unable to lock

Unable to unlock

Pinned

Unpinned

Unable to pin

Unable to unpin

Marked

Unmarked

Unable to mark

Reported as off topic

Known Issue

Fixed

Marked Fixed

Unmarked Fixed

Unable to mark fixed

Unable to unmark fixed

/profile/0

false