RANDBETWEEN Function - Removing numbers

[althea]

I am using the RANDBETWEEN function to pull random numbers from a list in Excel. I need to remove the numbers that are randomly selected from the main list. Any ideas on how I could do this?

 

[DaleWatson123321]

althea,

I recently developed a model that appears to be very close to what you've described.

Here's what it allows for:

1) On a sheet named "RandomNumbers", you enter your own series of numbers (that are completely arbitrary). They can be sequential numbers or any order. Your choice.

2) You enter on a separate sheet, a list of Names (Students or Employees for example). The sheet is named "Member_List"

3) On the "Member_List" sheet, there are three columns:
a) Sequential Number,
b) Participant Name
c) Participant Number

4) Also on the "Member_List" sheet, there is a macro button named: "Generate Participant Numbers".

When this button is clicked, it results in the Participant Number field being populated with a random selection of the numbers on the RandomNumbers sheet.

IMPORTANT: This routine ensures that there will be NO Duplicate Numbers assigned to the Participants.

5) There are SORT buttons on "Member_List" sheet - that allow for sorting by any of the three fields (Sequential Number, Participant Name, or Participant Number).

6) Names on the "Member_List" can entered ALL-at-once if preferred, but do NOT have to be. Names can be entered, and numbers (randomly) assigned as time allows, or as preferred. Any assigned numbers will be LEFT-as-is. ONLY members WITHOUT numbers will have random numbers assigned.

7) The list currently allows for up to 2,000 names, but can easily be expanded.

If you feel this is close to what you require, you're welcome to the file. This includes anyone else who might have a use for the file. Just email me, and I'll send the file via return email.

Regards, ...Dale Watson

WORK: dwatson@bsi.gov.mb.ca
HOME: nd.watson@shaw.ca

 

[althea]

Thanks Dale! Sounds like just what I need. I'll let you know how it goes!

 

[althea]

Hi,
I'm not able to remove the names from the list using this file. Do you have any ideas on how to do this? Anything that would remove/delete the names once they are randomly drawn?

 

[DaleWatson123321]

althea,

I'm not certain what you mean by: "removing the names", but if you're only referring to what you say, then the solution should be easy... just highlight the range of names, and delete.

If your situation is "more involved", perhaps you could email me the file back, with textboxes / arrows that specify exactly what you require.

I was as HOME today, so if you emailed me at work, I wasn't there to receive the email.

You can email me at HOME if you like.

Regards, ...Dale Watson

HOME: nd.watson@shaw.ca
WORK: dwatson@bsi.gov.mb.ca