Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Random letter and number generator
Hi, I am looking to find a function that can assign a set of random values to a column. For example if I have a list of names I want the spreadsheet to be able to churn out a random value for the following list, 3a 3b 3c 4a 4b 4c 5a 5b 5c Name Random Value M. Hardy 4a G. Dodd 5b B, Smith 3b The list needs to be able to be customized right up to 7a to allow for future expansion. Many thanks in advance, Marie -- Marie1uk ------------------------------------------------------------------------ Marie1uk's Profile: http://www.excelforum.com/member.php...o&userid=20984 View this thread: http://www.excelforum.com/showthread...hreadid=503643 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Random letter and number generator
Look in help for the function RAND(), in help for RAND there is also an
example of getting integers between certain values, you can use that then use that integer together with INDEX, put the values you want to assign in a range and lookup them, if non repeating values see: http://www.mcgimpsey.com/excel/udfs/randint.html -- Regards, Peo Sjoblom Portland, Oregon "Marie1uk" wrote in message ... Hi, I am looking to find a function that can assign a set of random values to a column. For example if I have a list of names I want the spreadsheet to be able to churn out a random value for the following list, 3a 3b 3c 4a 4b 4c 5a 5b 5c Name Random Value M. Hardy 4a G. Dodd 5b B, Smith 3b The list needs to be able to be customized right up to 7a to allow for future expansion. Many thanks in advance, Marie -- Marie1uk ------------------------------------------------------------------------ Marie1uk's Profile: http://www.excelforum.com/member.php...o&userid=20984 View this thread: http://www.excelforum.com/showthread...hreadid=503643 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Random letter and number generator
=TRUNC(RAND()*3+3)& CHAR(TRUNC(RAND()*3+97))
then drag fill down the column. -- Regards, Tom Ogilvy "Marie1uk" wrote in message ... Hi, I am looking to find a function that can assign a set of random values to a column. For example if I have a list of names I want the spreadsheet to be able to churn out a random value for the following list, 3a 3b 3c 4a 4b 4c 5a 5b 5c Name Random Value M. Hardy 4a G. Dodd 5b B, Smith 3b The list needs to be able to be customized right up to 7a to allow for future expansion. Many thanks in advance, Marie -- Marie1uk ------------------------------------------------------------------------ Marie1uk's Profile: http://www.excelforum.com/member.php...o&userid=20984 View this thread: http://www.excelforum.com/showthread...hreadid=503643 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Random letter and number generator
Thanks Tom, What values determine the minimum & maximum numbers (range), eg if I wanted it to only go from 3a to say 5a instead of 7 for some cells? -- Marie1uk ------------------------------------------------------------------------ Marie1uk's Profile: http://www.excelforum.com/member.php...o&userid=20984 View this thread: http://www.excelforum.com/showthread...hreadid=503643 |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Random letter and number generator
Any advice as to how I can tweak the range would be appreciated. Thanks -- Marie1uk ------------------------------------------------------------------------ Marie1uk's Profile: http://www.excelforum.com/member.php...o&userid=20984 View this thread: http://www.excelforum.com/showthread...hreadid=503643 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
random number with text | Excel Worksheet Functions | |||
random number question | Excel Worksheet Functions | |||
Count number of cells that contain a certain letter - Case Sensitive | Excel Discussion (Misc queries) | |||
Convert Text (letter) To Number Excel | Excel Worksheet Functions | |||
Random alpha generator | Excel Worksheet Functions |