Help with Excel

[Digital]

Hey! I have a task to do with excel but cannot figure a proper way to do it. I am doing an schoolwork where I need to set up a database, so I gathered some people information from fakenamegenerator.com . I got 5000 entries, but as my database is supposed to be about workers in a company I need to add a "working category" for all entries.

 

So I would like to create a list of possible working category, such as IT, security, management, accounting etc. and then spread those categories to the entries randomly - one for each. Can you figure a proper way of doing this?

[Guest]

8 minutes ago, Digital said:

snip

You want a way to enter 5,000 fake jobs?

[Digital]

Yes kind of

 

I'm trying now that I make a column where i put "RANDBETWEEN" like 1-10 and then i find and replace those numbers with job names. Is this stupid? 

[Guest]

 

=INDEX($B$1:$B$5,RANDBETWEEN(1,5),1)

 

 - =VALUE(From range of values you want to randomly assign, a random row(random number from 1 to 5), in column 1)

 

make sense?  

[Digital]

3 minutes ago, obi-fade-kenobi said:

*snip*

Yea, thats kind of what I was going to do too. Thanks!

[Guest]

1 minute ago, Digital said:

Yea, thats kind of what I was going to do too. Thanks!

$B$1:$B$5 is absolute reference if you weren't sure, meaning you can drag the formula down and it won't cock up. 

 

Other wise as you drag it you would get B2:B6, B3:B7 etc.