Excel Help

korme · 04-22-2004, 07:36 PM

I have a list of names in Column A, and a list of names in Column B, the lists are both the same size.

I am looking to concatenate column a and b, but what I can't figure out is how to pick the name from B randomly.

For instance, right now it's concatenating A1 and B1, A2 and B2 etc etc. I would like a random function where it randomly picks out one from column b, or even randomly picking from both columns.

Is this possible? If not, I could just scramble the lists but even that is something I don't yet know how to do.

sterlingice · 04-22-2004, 09:48 PM

Sorry, can't really help as I've never tried to do anything like that, but if you don't mind posting to newsgroups, the people at microsoft.public.excel.worksheet.functions are really helpful and I almost always get a response when I post a question about my hattrick spreadsheet.

When posting to a newsgroup, make sure to spoof your email address or else your inbox will become spam heaven. Spammers love to harvest emails off of newsgroup address lines and message bodies.

SI

FrogMan · 04-22-2004, 10:52 PM

Shorty, I've tried my hand at it. Some people moght have been able to come up with something easier, well, anyway...

Assuming I understand it right, here are the columns of data I had to start with, first names and last names...

First	Last
Bob	Edwards
Bill	Smith
Roberto	Jones
Sam	Tate
Jim	Alomar

And here's a bunch of randomly concatenated names the spreadsheet came up with...

concatenate

Bill Smith

Bob Smith

Sam Alomar

Bill Jones

Roberto Alomar

Bob Tate

Sam Tate

Jim Edwards

Roberto Alomar

Bill Jones

Sam Alomar

Sam Smith

Bill Alomar

Bill Tate

Bob Alomar

Sam Smith

Sam Edwards

Roberto Edwards

Bill Edwards

The function to get a random number between 0 and 1 ir =rand(). The function to get a particular line in one list is index...

The file is available right under here. Have fun with it, ask questions if needed. Hope it helps.
http://webhome.idirect.com/~stevegou...oncatenate.xls

FM

korme · 04-22-2004, 11:06 PM

fm, thankyou man!

and si, thanks, i'll keep that in mind for future references

Craptacular · 04-22-2004, 11:46 PM

Trying to come up with a porn name??

SlapBone · 04-23-2004, 12:00 AM

Johnson Long is a good one.

korme · 04-23-2004, 12:49 AM

just making a huge name list for a foreign league idea in ootp

04-22-2004, 09:48 PM	#2
sterlingice Hall Of Famer Join Date: Apr 2002 Location: Back in Houston!	Sorry, can't really help as I've never tried to do anything like that, but if you don't mind posting to newsgroups, the people at microsoft.public.excel.worksheet.functions are really helpful and I almost always get a response when I post a question about my hattrick spreadsheet. When posting to a newsgroup, make sure to spoof your email address or else your inbox will become spam heaven. Spammers love to harvest emails off of newsgroup address lines and message bodies. SI __________________ Houston Hippopotami, III.3: 20th Anniversary Thread - All former HT players are encouraged to check it out! Janos: "Only America could produce an imbecile of your caliber!" Freakazoid: "That's because we make lots of things better than other people!"

04-22-2004, 11:06 PM	#4
korme Go Reds Join Date: May 2001 Location: Bloodbuzz Ohio	fm, thankyou man! and si, thanks, i'll keep that in mind for future references

04-22-2004, 11:46 PM	#5
Craptacular College Starter Join Date: Oct 2001 Location: The Mad City, WI	Trying to come up with a porn name??

04-23-2004, 12:00 AM	#6
SlapBone High School JV Join Date: Nov 2003 Location: Houston, Texas	Johnson Long is a good one.

04-23-2004, 12:49 AM	#7
korme Go Reds Join Date: May 2001 Location: Bloodbuzz Ohio	just making a huge name list for a foreign league idea in ootp

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)