randbetween

Hi all, I have 379 sample identities in my Excel spreadsheet in A2:A380. I want to randomly assign a number from 1-5 to each of these. Can anyone recommend the most appropriate way to do this? Thanks!

Hi Guys. What I am trying to achieve: A Single form to create quotes and orders, with a cell that generates a random quote number each time the form is amended. The quote number must be different if an amendment has been made to the document. The quote number needs to then become a static fixed...

Hi all, I know how to create a random number between a set of numbers (i.e. =randbetween(1,99999), however, I cannot find a way to have the number "freeze", or hold from regeneration, when I re-open the spreadsheet, press F9, or decide to add another row for a new number to generate. Any ideas...

Hello dear excel users, how can I use RANDBETWEEN to list the result in an ascending order. Thanking you. Regards, KHARDU

Hi All I am new to Excel so Hi! I need to create a game in Excel, and usually quite a competent user, however for this game I just cannot get my head around even how to start or approach it! (Excel 2007 btw!) So here goes ... The game is based on 15 rounds/turns of rolling, with each turn...

Hello all and thank you for allowing me onto the Mr.Excel message boards, I just have one quick question for you guys and I'm sure it's trivial... Let me explain my situation. :biggrin: My information systems 102 prof, (St. Francis Xavier University, Eastern Canada) post-midterm, realized...

I was helping out another forum member with a solution to the following problem: http://www.mrexcel.com/forum/showthread.php?t=596276 I created a working code solution, but it has to be optimized. Can one of the VBA experts out there make some suggestions to significantly speed up this code...

Hi there, My co-worker and I are trying to solve a excel riddle and we'd love some help to find an answer (if there's one)! We're trying to use Excel to randomize fourteen individual sums that add up in total a certain amount of money but doesn't go pass said amount. So an example is 1-14...

Hi there, I have a Workbook with 2 worksheets, on Sheet1 there is a list of Competition winners, in Column A on Sheet1 there is a unique entry number. i.e. 123249. On Sheet2 there is a table column A consists of a Heading "#" then 1-26 under that until row 27. Column B has the heading Winners...

I have a number of forumals that look like the following, My issue is I am using Openoffice.org and the limit is “choose” 30 Any suggestions ?? please help. Sorry No I can not install Office that has a larger limit...