Excel Magic Trick #19: Randomly Generate Words

[LadyDboz]

@ExcelIsFun Hi, thanks a lot for you videos. They have been of great use to me. Amazing stuff.

Could you tell me the shortcut key for zooming , i saw you doing so at 1:05

Many Thanks

[ExcelIsFun]

@LadyDboz , Ctrl and then roll wheel on Mouse.

[LadyDboz]

@ExcelIsFun Cheers!

[TheMatchMakerMan]

This was a very big help to me for my Management 600 class!

[nemanjanv7]

Hey I really like your videos. Must say it's a nice and noble thing your doing :D

I have one question about his video. I've got a similar problem - Let's say I have about 800 names in column A (from A1 to A800, naturally). Now I need one of these names to be randomly selected. How do I do that quickly?

there is one way: =CHOOSE(RANDBETWEEN(1;800);A1;­A2;A3;A4;etc.,;a800), but it would take me a whole day to do it that way.

[ExcelIsFun]

Try:

=INDEX($A$1:$A$800,INT(RAND()*­800+1))

[nemanjanv7]

Thank you very very much, it really works. Although I still don't understand how the last part functions, I'm sure I'll find it as I go through your videos. Thanks

[xxsweetGxx]

your voice is cool !

:)

[ExcelIsFun]

Dear xxsweetGxx ,

Most of the comments i get are that people dislike my voice. But I can't help it, that's just the way it comes out.

--ExcelIsFun

[xxsweetGxx]

Well that's not very nice of them because I like your voice its so much more exciting than other people who have tutorials like this and have half dead/boring voices atleast your enthusiastic the whole time :) Plus I think your voice would be great in a cartoon !

[ExcelIsFun]

Dear xxsweetGxx,

Cool!!! That would be great! We could make cartoons about how to use Excel. I would love to do the voice for that! We could also have Excel Superheroes that come in and save the day!!

--ExcelIsFun