No. MRAND spits out numbers. What!? You don't know what INDEX does? INDEX is probably #4 on the all-time list of Excel functions (SUM, VLOOKUP, IF, INDEX). INDEX is mind-blowing in what it can do. Immediately: Go to the Highline Excel Class Playlist and watch #43, 44, and 45! After you are done, your Excel glasses will be beneficially altered to properly see INDEX as a big chunk of the Excel magic!
Thank you, I will be back for more. Been looking to do random names in selected cells forever. The one other thing I've been looking for, is transferring a list of names to use in a letter, to personalize same letter with each name.
Thank you for this great instructional video! I found it very useful! I want to use this in a classroom setting where I randomly call on students and don't ask the same student twice. Can you have it select one name without repeating? (By this, I mean, can you use this with only one cell and have it so that every time it re-calculates it will remember what it picked?) Or is this beyond the functions of excel?
sir u learned me a lot thx foe every step that i learened while watching u ,can i know how can i make random if the data is in three column and i need 2 winners
Hi, if you can't use MRAND (it's by far a more efficient and elegant approach) in B11 ( B10 does not house any number) =IFERROR(AGGREGATE(15,6,ROW($1:$50)/(COUNTIF($B$10:B10,ROW($1:$50))=0),RANDBETWEEN(1,50-COUNT(B$10:B10))),"") or using Excel 2007 =IFERROR(SMALL(IF(COUNTIF($B$10:B10,ROW($1:$50))=0,ROW($1:$50)),RANDBETWEEN(1,50-COUNT(B$10:B10))),"") Array entered (to be confirmed with control+shift+enter) Just for fun
HI great video. I have a question. I have the MoreFunc Excel add-in and used this fucntion, which is fine. However, I want to sent the file so my friend can use. Is there a way he can use this new function without downloading the add in pack also? I thought saving the file as .xlam did this??? Thanks.
Help required, for some reason, i have done the MRAND function but when ever i enter a value or anything in another cell and press enter, it randomly changes the cells i selected for the MRAND functions to work on but i dont want that to change. I thought only F9 would randomly change the scenario but there appears to be a fault or im doing something wrong please advise
Hi I use the same formula in the same way but when I click Ctrl+Shift +entre it puts a bracket on both sides and in the selected cell #Name comes. what am I doing wrong??????????????????? please
You have to use ctrl+ shift+ enter, but I find out you have to download the zip drove with all the extra formulas, my computer didn't read this formulas add a valid formula