Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Topic did not show up?
I posted a topic yesterday but it has yet to show up and no longer have
those notes... so bear with me. I am wanting to have inside a cell: REV: username - now() random-8-characters I would want it to look something like REV: Jason Sands - 28 Nov 2006 - y3V6Bk4A I had a lot more detailed message yesterday but I think GMail lost it... |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Topic did not show up?
Here's a UDF
Function RandIt() Dim tmp Dim randvals(1 To 3) As Long Dim i As Long tmp = Application.UserName & " - " & Format(Date, "dd mmm yyyy") & " - " Randomize For i = 1 To 8 randvals(1) = Int((57 - 48 + 1) * Rnd + 48) randvals(2) = Int((90 - 65 + 1) * Rnd + 65) randvals(3) = Int((121 - 97 + 1) * Rnd + 97) tmp = tmp & Chr(randvals(Int((Rnd() * 3) + 1))) Next i RandIt = tmp End Function in the worksheet =RandIt() -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "Jason Sands" wrote in message ups.com... I posted a topic yesterday but it has yet to show up and no longer have those notes... so bear with me. I am wanting to have inside a cell: REV: username - now() random-8-characters I would want it to look something like REV: Jason Sands - 28 Nov 2006 - y3V6Bk4A I had a lot more detailed message yesterday but I think GMail lost it... |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Topic did not show up?
Hi. Try: =A1&" - "&TEXT(TODAY(),"dd mmm yy")&" - "&MID(ADDRESS(1,RANDBETWEEN(1,26)),2,1)&RANDBETWEE N(0,9)&MID(ADDRESS(1,RANDBETWEEN(1,26)),2,1)&RANDB ETWEEN(0,9)&MID(ADDRESS(1,RANDBETWEEN(1,26)),2,1)& RANDBETWEEN(0,9)&MID(ADDRESS(1,RANDBETWEEN(1,26)), 2,1)&RANDBETWEEN(0,9) Where A1 houses the user name. You need to install Analysis Toolpak for RANDBETWEEN() to work. Tools-Addins-Analysis Toolpak. HTH Regards, Jon von der Heyden -- Jon von der Heyden ------------------------------------------------------------------------ Jon von der Heyden's Profile: http://www.officehelp.in/member.php?userid=4852 View this thread: http://www.officehelp.in/showthread.php?t=1245029 Posted from - http://www.officehelp.in |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Topic did not show up?
Works great!
For those wondering how to UDF: http://office.microsoft.com/en-us/as...548461033.aspx Jason Bob Phillips wrote: Here's a UDF Function RandIt() Dim tmp Dim randvals(1 To 3) As Long Dim i As Long tmp = Application.UserName & " - " & Format(Date, "dd mmm yyyy") & " - " Randomize For i = 1 To 8 randvals(1) = Int((57 - 48 + 1) * Rnd + 48) randvals(2) = Int((90 - 65 + 1) * Rnd + 65) randvals(3) = Int((121 - 97 + 1) * Rnd + 97) tmp = tmp & Chr(randvals(Int((Rnd() * 3) + 1))) Next i RandIt = tmp End Function in the worksheet =RandIt() -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "Jason Sands" wrote in message ups.com... I posted a topic yesterday but it has yet to show up and no longer have those notes... so bear with me. I am wanting to have inside a cell: REV: username - now() random-8-characters I would want it to look something like REV: Jason Sands - 28 Nov 2006 - y3V6Bk4A I had a lot more detailed message yesterday but I think GMail lost it... |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Show last number entered | Excel Discussion (Misc queries) | |||
Show data used and percent label | Charts and Charting in Excel | |||
leading zeros are not showing in the formula bar but do show in ce | Excel Discussion (Misc queries) | |||
Show values from other sheet | Excel Worksheet Functions | |||
with formulas that show negative results I want to show zero inste | Excel Discussion (Misc queries) |