Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
About the usage of the function
As I am the president of dance club in my university, I wants to assign a
4-digit password consisting of alphabets and numeric digit to each member for our club intranet, can I use the function of excel to do it? Thank you |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
About the usage of the function
What exactly do you want to function to do? Generate a random 4 digit
password (note that there are 1,676,616 combinations)? Store information? A 'random' generator setup: First, go to Tools, Add-Ins, activate the Analysis ToolPak. In A1:A36, place numbers 1 - 36. In B1:B36 place a -z, and 1-0 Generator formula: =LOOKUP(RANDBETWEEN(1,36),A1:B36)&LOOKUP(RANDBETWE EN(1,36),A1:B36)&LOOKUP(RANDBETWEEN(1,36),A1:B36)& LOOKUP(RANDBETWEEN(1,36),A1:B36) You can now press F9 to generate another random combination. -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "Keith Hui" wrote: As I am the president of dance club in my university, I wants to assign a 4-digit password consisting of alphabets and numeric digit to each member for our club intranet, can I use the function of excel to do it? Thank you |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
reverse lookup function, index/match usage? | Excel Worksheet Functions | |||
Function usage and outcome clarification | Excel Worksheet Functions | |||
100% cpu usage | Excel Discussion (Misc queries) | |||
Restricted Usage | Excel Discussion (Misc queries) | |||
Usage of sumif | Excel Discussion (Misc queries) |