by Ilker | Apr 16, 2018 | Excel Tips & Tricks
Managing and coming up with strong passwords can be challenging. Let us show you how you can create your own custom password generator in Excel. You can download our sample workbook below. Download Workbook Syntax Random Character Generation =RANDBETWEEN(0,9)...
by Ilker | Apr 16, 2018 | Excel Tips & Tricks
Do you have a list of items or names that you want to sort randomly? Using the RANDBETWEEN, RANK, and INDEX functions in conjunction, you can easily shuffle an item group for a random draw. Syntax =RANDBETWEEN( 1, number of list items ) + ROW() / very large number...
by Ilker | Apr 4, 2018 | Excel Tips & Tricks
Sure, it’s easy to find the highest or smallest values in a data set. But what if you’re looking for the 3rd, 10th, 20th rank in a large table, or need to do this in ascending and descending order? Luckily, Excel features a formula that does just that....