## Randomly Pick A Name Only Once |

## Randomly Pick A Name Only Once - Excel |
View Answers |

I have a list of 50 names and need to pick 10 of those names at random. Each name can be picked only once. Can you please help me out with the code for this. I have experimented with =Rand() with no luck and =INDEX($A$1:$A$50,RANK(C1,$C$1:$C$10)) with no luck. I have also tried =INDEX(A:A,RANDBETWEEN(1,COUNTA(A:A))). I must be missing something.

All names are in A1:A20 and I would like to display the 10 randomly picked names in C1:C10.

Thanks

All names are in A1:A20 and I would like to display the 10 randomly picked names in C1:C10.

Thanks

## Subscribe for Weekly Excel Tips and Tricks

### Helpful tutorials delivered to your email!

## Similar Topics

Is it possible to assign values to names in a list, so that when you validate

it as a drop-down list, you can select a name from the drop-down and it's

corresponding value will be added to separate cell? Basically, I have survey

questions which have five possible responses: Excellent - Very Good - Good -

Fair - Poor. We want to assign a value to each, 5 for Excellent, 4 for Very

Good and so on, so that when a response is selected from a drop-down, it's

value appears in a separate cell (so that we can calculate a total and

average score from the selections).

Thanks

B

it as a drop-down list, you can select a name from the drop-down and it's

corresponding value will be added to separate cell? Basically, I have survey

questions which have five possible responses: Excellent - Very Good - Good -

Fair - Poor. We want to assign a value to each, 5 for Excellent, 4 for Very

Good and so on, so that when a response is selected from a drop-down, it's

value appears in a separate cell (so that we can calculate a total and

average score from the selections).

Thanks

B

I have and excel sheet that was a contact list apparently exported wrong and has the names and addresses all together in each cell in about 350 rows in column A, they are all in this format

john doe email address here

for some reason the email address in brackets won't show up here but each email address is in brackets

I need to get the name in one column and the email address without the brackets into another, any ideas?

john doe email address here

for some reason the email address in brackets won't show up here but each email address is in brackets

I need to get the name in one column and the email address without the brackets into another, any ideas?

Hi All,

Random question i have a large Excel Workbook (which is protected) and has over five sheets on it - however one sheet has randomly decided not to scroll... yes i know sounds random! If i use the cursor and down arrows the selection just disappears off the screen.

The page will scroll if i filter by one field, but not if i select (All) for all filters.

All other worksheets scroll fine.

Any suggestions?

Thanks in advance.

Cheers Kaite

Random question i have a large Excel Workbook (which is protected) and has over five sheets on it - however one sheet has randomly decided not to scroll... yes i know sounds random! If i use the cursor and down arrows the selection just disappears off the screen.

The page will scroll if i filter by one field, but not if i select (All) for all filters.

All other worksheets scroll fine.

Any suggestions?

Thanks in advance.

Cheers Kaite

Hi everyone

I need some help in this:

In a excel workbook when I copy a worksheet (to duplicate with other name) there is always a name conflict and so I have to say yes (maintain the name) or say no (and excel ask for other names) many times (sometimes more than 50 times pressing the enter button. Its possible to disable this feature?

My best regards and Thanks in advance.

Melnik Kuhn

I need some help in this:

In a excel workbook when I copy a worksheet (to duplicate with other name) there is always a name conflict and so I have to say yes (maintain the name) or say no (and excel ask for other names) many times (sometimes more than 50 times pressing the enter button. Its possible to disable this feature?

My best regards and Thanks in advance.

Melnik Kuhn

I need to find data in two different formats within a column

Examples

Webb Christopher

Greer Nancy

I need to find cells with text that have more than one space between the first and last names; and cells with text that have only one space between the first and last names.

I am fairly new to excel. I can find the space after the first word but cannot tell it to find ones that say have a space then another string of text.

Thank you for your help!

Examples

Webb Christopher

Greer Nancy

I need to find cells with text that have more than one space between the first and last names; and cells with text that have only one space between the first and last names.

I am fairly new to excel. I can find the space after the first word but cannot tell it to find ones that say have a space then another string of text.

Thank you for your help!

This is probably an easy question for most of you, but it's killing me. I tried searching before I posted this, but the suggestions given didn't seem to work for me.

I need to look up data from a cell on one Excel sheet, compare it to a list on a 2nd sheet and when they equal, take a value from a different column on the 2nd sheet and drop it back on the 1st sheet. Since that's a horrible explanation, let me try explaining it this way:

Sheet 1

Column A has a long list of code type 1s

Column E has a long list of code type 2s

Sheet 2

Cell C2 has code 1

Cell E2 needs code 2

I know it should take an index/match function, but nothing I try is working. What I'm trying is the following formula in Cell E2 of sheet 2:

=INDEX('Sheet 1'!A:A,MATCH(C2,'Sheet 1"!E:E,0),5)

But all I get is no result. What's driving me bonkers is that if I copy everything over to a single sheet, that formula works fine.

I need to look up data from a cell on one Excel sheet, compare it to a list on a 2nd sheet and when they equal, take a value from a different column on the 2nd sheet and drop it back on the 1st sheet. Since that's a horrible explanation, let me try explaining it this way:

Sheet 1

Column A has a long list of code type 1s

Column E has a long list of code type 2s

Sheet 2

Cell C2 has code 1

Cell E2 needs code 2

I know it should take an index/match function, but nothing I try is working. What I'm trying is the following formula in Cell E2 of sheet 2:

=INDEX('Sheet 1'!A:A,MATCH(C2,'Sheet 1"!E:E,0),5)

But all I get is no result. What's driving me bonkers is that if I copy everything over to a single sheet, that formula works fine.

Hello

I'm quite experienced Excel user. I've never come across this problem but tinkering in every conceivable way within Excel settings and the solution has eluded me.

I have added a worksheet created elsewhere (it is a form I need printing, with the data coming from 2 sheets I have created from scratch) which has pre formatted cells for Date and Client Name etc.

When I try to reference the cell in this added sheet from my 2 sheets, instead of the result, it always displays the formula, not the result.

I have tried doing it from one of my sheets to reference to this new, and that displays the result and not formula. I can't imagine why it's doing this and I've never seen it happen before.

Formatting cells, giving cells names rather than the usually adequate of reference to the Cell Number doesn't change things. I wonder if I've picked up some legacy protection from the original form but can't see anywhere in the tools etc that's obvious.

There's about 50+ cells that need referencing and I got to get this done for work.

Please help me. This is my first need to post on a Excel Forum as I've always found help or answers from other peeps or internet but this one is making me scratch my head big time.

I'm quite experienced Excel user. I've never come across this problem but tinkering in every conceivable way within Excel settings and the solution has eluded me.

I have added a worksheet created elsewhere (it is a form I need printing, with the data coming from 2 sheets I have created from scratch) which has pre formatted cells for Date and Client Name etc.

When I try to reference the cell in this added sheet from my 2 sheets, instead of the result, it always displays the formula, not the result.

I have tried doing it from one of my sheets to reference to this new, and that displays the result and not formula. I can't imagine why it's doing this and I've never seen it happen before.

Formatting cells, giving cells names rather than the usually adequate of reference to the Cell Number doesn't change things. I wonder if I've picked up some legacy protection from the original form but can't see anywhere in the tools etc that's obvious.

There's about 50+ cells that need referencing and I got to get this done for work.

Please help me. This is my first need to post on a Excel Forum as I've always found help or answers from other peeps or internet but this one is making me scratch my head big time.

Hello, I'm trying to count the number of times a name appears across multiple worksheets but I can't seem to figure it out.

I have 6 sheets to count and all the names are in column A (from A1:A100) on each sheet. The names are not in a particular order.

On sheet 7 I want to have a cell beside each persons name that counts the number of times their name appeared on the other 6 sheets.

For example Sheet 7 (called total) would have

Joe 5 (where 5 is the outcome of the formula I'm looking for to count all the times "Joe" appears on sheets 1-6).

I have it counting per sheet with =COUNTIF(A1:A130,"name") but this is not quite what I am looking for.

Thanks in advance for any advice.

Edit: I am using Excel 2007 w/ windows XP

I have 6 sheets to count and all the names are in column A (from A1:A100) on each sheet. The names are not in a particular order.

On sheet 7 I want to have a cell beside each persons name that counts the number of times their name appeared on the other 6 sheets.

For example Sheet 7 (called total) would have

Joe 5 (where 5 is the outcome of the formula I'm looking for to count all the times "Joe" appears on sheets 1-6).

I have it counting per sheet with =COUNTIF(A1:A130,"name") but this is not quite what I am looking for.

Thanks in advance for any advice.

Edit: I am using Excel 2007 w/ windows XP

Ok, guys, new to this forum and I need some help with a business invoice. I know how to create a drop down list. But what I want to do is create a Drop-Down list with customers names, say cell A11. After selecting a customer name from the list, It would be able to populate the address in cells A12 and A13. Is this possible?

Good Morning Folk

Is there a way to sort a list of names alphabetically and put any blank cells to the bottom rather than the top

Cheers Jim

Is there a way to sort a list of names alphabetically and put any blank cells to the bottom rather than the top

Cheers Jim

Hi there! I have a workbook that is having an issue with drop down menu's. When I click in a cell the little drop down arrow appears and when I go to click on the drop down arrow nothing happens. The drop down list does not appear.

BUT.......if I click in the cell and right click and chose "pick from list" the list will then appear.

Why is this happening? Why does the drop down list not appear when I click on the arrow but only work if I chose the "pick from list" ???

I need the drop down arrow to work

BUT.......if I click in the cell and right click and chose "pick from list" the list will then appear.

Why is this happening? Why does the drop down list not appear when I click on the arrow but only work if I chose the "pick from list" ???

I need the drop down arrow to work

Right now I have a sports league with 8 teams, I'd like to create a random 7-game schedule where each team plays the other team only once. Essentially this will be a 7-game round robin. However, I'd like to be able to use this for any number of teams and games.

I'd like to do this in Excel, but I can't figure out how to have a randomly generating non-repeating macro with text values in cells.

So right now I have a column of 8 values and need matrix of 7 columns by 8 rows next to it.

I've found this thread that has one for numbers, but I can't figure out how to do it for text values...

http://www.excelforum.com/excel-prog...m-numbers.html

Thanks all!

I'd like to do this in Excel, but I can't figure out how to have a randomly generating non-repeating macro with text values in cells.

So right now I have a column of 8 values and need matrix of 7 columns by 8 rows next to it.

I've found this thread that has one for numbers, but I can't figure out how to do it for text values...

http://www.excelforum.com/excel-prog...m-numbers.html

Thanks all!

I have a sheet with a list of names on and I've noticed that when I use ctrl+F to use the find function, even when I know i have entered the correct name it still will not work. I have identifed times when I know the name is there on the sheet, but the find function says "Excel cannot find the data you are searching for"

Im unable to put any pics up as my work pc has java disable so photobucket ect won't work but has anyone else come across this problem and how did you rectify it? A search macro perhaps?

Im unable to put any pics up as my work pc has java disable so photobucket ect won't work but has anyone else come across this problem and how did you rectify it? A search macro perhaps?

Thought I'd append my experience of the above problem - you can find all sorts of references to it everywhere.

My problem was that a userform defined with Excel at work (containing DT pickers) gave the message in the title when opening it at home. I had a light-bulb moment and wondered whether there was a difference in the version numbers for MSCOMCT2.OCX at work and at home. Turned out the work version was newer. I then copied the MSCOMCT2.* files from work, made a backup of them at home and copied those from work to my C-drive (Windows XP - c:\windows\system32\ ).

No luck. I then rebooted the machine - still no luck.

Then, finally I unregistered the old DLL via

Code:

(not sure if this was necessary, but I didn't think it could hurt). Reregistered the DLL via

Code:

and what do you know - it worked.

Summa summarum - it could be an idea to check whether the two machines have different version numbers for the MSCOMCT2.OCX files.

My problem was that a userform defined with Excel at work (containing DT pickers) gave the message in the title when opening it at home. I had a light-bulb moment and wondered whether there was a difference in the version numbers for MSCOMCT2.OCX at work and at home. Turned out the work version was newer. I then copied the MSCOMCT2.* files from work, made a backup of them at home and copied those from work to my C-drive (Windows XP - c:\windows\system32\ ).

No luck. I then rebooted the machine - still no luck.

Then, finally I unregistered the old DLL via

Code:

regsvr32 /u c:\windows\system32\MSCOMCT2.OCX

(not sure if this was necessary, but I didn't think it could hurt). Reregistered the DLL via

Code:

regsvr32 c:\windows\system32\MSCOMCT2.OCX

and what do you know - it worked.

Summa summarum - it could be an idea to check whether the two machines have different version numbers for the MSCOMCT2.OCX files.

Hi all,

Probably a simple little function, help would be appreciated!

I'd like to take a number entered into one cell ie. A1 = 20

and split it randomly but evenly over 3 other cells ie.

B1=6

C1=8

D1=6

Number should be whole and no zeros?

Thanks all!

Probably a simple little function, help would be appreciated!

I'd like to take a number entered into one cell ie. A1 = 20

and split it randomly but evenly over 3 other cells ie.

B1=6

C1=8

D1=6

Number should be whole and no zeros?

Thanks all!

Hello gurus!

Here's my question...I have a list of numbers and I want to know how many combinations (and what they are) of adding the numbers will equal an amount.

e.g.

List of Numbers

1

2

3

4

5

6

7

8

9

10

Amount to be reached = 12

These are some of the possible combinations to reach 12 :

2+10

3+9

4+8

5+7

3+4+5

6+3+2+1

Is there a function in Excel that will do this for me? I want to know which numbers (i.e. cells) can be added to reach 12. AND, if possible, colorcode the cells added for each combination.

Good luck and thanks!!

Here's my question...I have a list of numbers and I want to know how many combinations (and what they are) of adding the numbers will equal an amount.

e.g.

List of Numbers

1

2

3

4

5

6

7

8

9

10

Amount to be reached = 12

These are some of the possible combinations to reach 12 :

2+10

3+9

4+8

5+7

3+4+5

6+3+2+1

Is there a function in Excel that will do this for me? I want to know which numbers (i.e. cells) can be added to reach 12. AND, if possible, colorcode the cells added for each combination.

Good luck and thanks!!

Hey all,

Coffee hasn't hit my brain yet this morning and I cant figure this one out.

I have a list of names that are in the following format:

LastName Suffix, FirstName MI

The middle initial is not always present, neither is the suffix. For simplicity purposes, we will assume the suffix can ONLY be "Jr."

Here is some sample data:

Brown Jr., Wayne

Fowler, Michael

Parker, David A

Winstead Jr., Johnny N

I want the output to be the following:

Brown, Wayne

Fowler, Michael

Parker, David

Winstead, Johnny

Thanks in advance for the help!

PS (if i can get a formula that at least gets rid of the middle initial at the end (if it exists), then that would be a HUGE step in the right direction, as the Jr. only occurs on maybe 3% of my data. The middle initial is in about 80% of the data.

Coffee hasn't hit my brain yet this morning and I cant figure this one out.

I have a list of names that are in the following format:

LastName Suffix, FirstName MI

The middle initial is not always present, neither is the suffix. For simplicity purposes, we will assume the suffix can ONLY be "Jr."

Here is some sample data:

Brown Jr., Wayne

Fowler, Michael

Parker, David A

Winstead Jr., Johnny N

I want the output to be the following:

Brown, Wayne

Fowler, Michael

Parker, David

Winstead, Johnny

Thanks in advance for the help!

PS (if i can get a formula that at least gets rid of the middle initial at the end (if it exists), then that would be a HUGE step in the right direction, as the Jr. only occurs on maybe 3% of my data. The middle initial is in about 80% of the data.

I have a large database with names, addresses etc. When I try to make changes

to the email address, like change the font color or change on letter, Excel

tries to email the address. If I click in the formula bar to make the

changes, it automatically changes it back to all blue text and underlined. I

have tried to format all of the cells as "Text" to show as entered, but it

doesnt work. PLEASE HELP

to the email address, like change the font color or change on letter, Excel

tries to email the address. If I click in the formula bar to make the

changes, it automatically changes it back to all blue text and underlined. I

have tried to format all of the cells as "Text" to show as entered, but it

doesnt work. PLEASE HELP

I have a given length of steel bar...Example(550 feet)

I have various cut lengths that I can pick from...

14'-10".....13'- 9".. 12'-8"........(up to 6 different lengths)

I need to know the best combination of lengths to cut the long bar into to have minimal scrap left when we get to the end of the 550 feet.....

Cut as many of the longest cut lengths possiable.....Cut as few of the shortest cut lengths possiable

Due to the fact that I will have to convert this to a PLC application when completed, I want to find a mathmatical way to do this inside excel and not use the "solver"....Assuming that I/we can come up with an equation to do this .....

Any and all advice/help would be appricated.....

I have various cut lengths that I can pick from...

14'-10".....13'- 9".. 12'-8"........(up to 6 different lengths)

I need to know the best combination of lengths to cut the long bar into to have minimal scrap left when we get to the end of the 550 feet.....

Cut as many of the longest cut lengths possiable.....Cut as few of the shortest cut lengths possiable

Due to the fact that I will have to convert this to a PLC application when completed, I want to find a mathmatical way to do this inside excel and not use the "solver"....Assuming that I/we can come up with an equation to do this .....

Any and all advice/help would be appricated.....

I am a very advanced Excel user so this is a new one for me.

When I open any spreadsheet (new or already populated) the black box that normally frames the active cell is missing (showing which cell you have selected). Likewise when I 'select all' the sheet does not become shaded.

In addition:

Can not fill series

Can not change cell format (specifically to show Currency or Accounting w/$ symbol)

And I am sure there is much more that I have not found yet. I have not seen a single thread on this topic anywhere on the internet.

Help!

When I open any spreadsheet (new or already populated) the black box that normally frames the active cell is missing (showing which cell you have selected). Likewise when I 'select all' the sheet does not become shaded.

In addition:

Can not fill series

Can not change cell format (specifically to show Currency or Accounting w/$ symbol)

And I am sure there is much more that I have not found yet. I have not seen a single thread on this topic anywhere on the internet.

Help!

I am importing data to a cell. The data is actually html code. I would like

to display the data formatted. Right now I get all the ugly html codes, like

<b> Hello World</>.

Thanks - John

to display the data formatted. Right now I get all the ugly html codes, like

<b> Hello World</>.

Thanks - John

This may be less of an Excel question than a general data display question, but I'll try here.

I have 3 variables that I'm charting. I have one on the primary axis and it's values are in the billions. I have one on the secondary axis and it's a percentage. I need to display a 3rd who's value is in the millions. If I put it on the primary axis, you cannot see modest changes.

Is there a tricky way to get all three on one graph? I know I could split on two graphs, so that's my backup plan.

Thanks,

Dave

I have 3 variables that I'm charting. I have one on the primary axis and it's values are in the billions. I have one on the secondary axis and it's a percentage. I need to display a 3rd who's value is in the millions. If I put it on the primary axis, you cannot see modest changes.

Is there a tricky way to get all three on one graph? I know I could split on two graphs, so that's my backup plan.

Thanks,

Dave

Hi all,

I have some formulae in A1, is it possible for cell B1 to display the value only of A1 without the link to the formulae. I dont want to have to run a macro, or paste values, more of a formula that could be assigned to cell B1 so whenever A1 is changed, so is B1 automatically.

Thanks,

Pedro.

I have some formulae in A1, is it possible for cell B1 to display the value only of A1 without the link to the formulae. I dont want to have to run a macro, or paste values, more of a formula that could be assigned to cell B1 so whenever A1 is changed, so is B1 automatically.

Thanks,

Pedro.

Hi everyone....this is my first post here ....and not my last I believe!

My question I believe is easily solvable for you cracks of excel.

I have a worksheet with a list of rows (item#, date, price, etc). In the last column of this list I can put an x for some of the items.

On another worksheet or sheet, I need to autoamtically have a list of the items in the first list above, that have an X in the last columns.

I created an example on a worksheet attached just for you to understand.

I apreciate all the help I can get.

Thank you so much.

RG

My question I believe is easily solvable for you cracks of excel.

I have a worksheet with a list of rows (item#, date, price, etc). In the last column of this list I can put an x for some of the items.

On another worksheet or sheet, I need to autoamtically have a list of the items in the first list above, that have an X in the last columns.

I created an example on a worksheet attached just for you to understand.

I apreciate all the help I can get.

Thank you so much.

RG

A previous poster explained what I also need; there were no responses,

so I thought I would try again.

Does anyone know of an Excel template--or a small stand-alone

program--that will calculate the interest/principal breakdown when

payments are varied in amount and frequency? Free or low-cost, please.

I need one that will work on my Mac/Office 2004. I will need to print

out periodic reports.

Here is the way the previous poster described it:

"Excel template: Loan Amortization for random/irregular payments,

figures days

between payment dates.

I have a loan with a variable beginning balance and irregular payments

with

annual large payment. (based on collections)

Would like to enter payment and date.

then Excel would figure days since last payment, interest amount,

principal

amount, Ending Principal balance.

And total interest paid, total pricipal paid

If I change the starting principal, excel would recalculate all

entries."

Thanks very much.

so I thought I would try again.

Does anyone know of an Excel template--or a small stand-alone

program--that will calculate the interest/principal breakdown when

payments are varied in amount and frequency? Free or low-cost, please.

I need one that will work on my Mac/Office 2004. I will need to print

out periodic reports.

Here is the way the previous poster described it:

"Excel template: Loan Amortization for random/irregular payments,

figures days

between payment dates.

I have a loan with a variable beginning balance and irregular payments

with

annual large payment. (based on collections)

Would like to enter payment and date.

then Excel would figure days since last payment, interest amount,

principal

amount, Ending Principal balance.

And total interest paid, total pricipal paid

If I change the starting principal, excel would recalculate all

entries."

Thanks very much.