Generate random numbers in Excel
john lilleystone • March 1, 2020
Get Excel to generate random numbers between two thresholds.
Not one you'll use everyday but keep it in your back pocket for when the time comes. You never know, it might just pick out your winning Lotto numbers!
Replace ugly Excel errors returned by a formula with something more appropriate and pleasing to the eye.
Don't waste time manually editing queries to move the date period on one month. This blog explains how to use DATEADD to dynamically shift the dates on one month on each refresh
Import text files into Excel and use the Text to Columns wizard to separate the data into columns
Extract values or strings from a cell from either the left, middle or right part of the cell
