Excel Rand

Posted on By David Kittell

Great if you are creating random passwords, more examples at the reference link below.

=CHAR(RANDBETWEEN(65,90))& CHAR(RANDBETWEEN(65,90)) & CHAR(RANDBETWEEN(65,90)) & CHAR(RANDBETWEEN(65,90))

=CHAR(RANDBETWEEN(65,90))& CHAR(RANDBETWEEN(65,90)) & CHAR(RANDBETWEEN(65,90)) & CHAR(RANDBETWEEN(65,90)) & CHAR(RANDBETWEEN(65,90)) & CHAR(RANDBETWEEN(65,90)) & CHAR(RANDBETWEEN(65,90)) & CHAR(RANDBETWEEN(65,90))

Reference: http://excel.tips.net/T003872_Generating_Random_Strings_of_Characters.html

Originally Posted on August 11, 2015
Last Updated on October 26, 2015
All information on this site is shared with the intention to help. Before any source code or program is ran on a production (non-development) system it is suggested you test it and fully understand what it is doing not just what it appears it is doing. I accept no responsibility for any damage you may do with this code.
Code Excel

Related Posts

Get Windows Shortcut (.lnk) Details

Posted on

The below will help you get the full path of a Windows shortcut (.lnk) in your program. The below examples specifically create a command-line executable file but you could use the function in your program just as well. View the full code in GitHub at https://github.com/dkittell/lnk-parser using System; using System.Collections.Generic;…

Read More

Distinct For Only One Column

Posted on

name sold_price ram 2000 shyam 3000 ram 4000 hari 50000 Want: name sold_price ram 2000 shyam 3000 hari 50000 Show first reference of ram SELECT name,sold_price FROM ( SELECT ID ,name ,sold_price ,ROW_NUMBER() OVER ( PARTITION BY name ORDER BY ID ) rn FROM shop ) a WHERE rn =…

Read More

GitLab – Folder Permissions Fix

Posted on

If you’ve ran into a directory permissions problem with GitLab before this may be helpful. The code below is mostly based on GitLab documentation – https://docs.gitlab.com/omnibus/settings/configuration.html # Holds repositories directory sudo chown -R -v git:root /var/opt/gitlab/git-data sudo chmod -R -v 0700 /var/opt/gitlab/git-data # Holds git repositories sudo chown -R -v…

Read More