by admin | Nov 30, 2020 | Excel | General
A while back one of my customers asked me about a way to create a unique ID from a customer’s name and a random number. Of course I was intrigued and using a combination of Left(), Right() and Randbetween() helped her do just that. Yum, I do love me an Excel...
by admin | May 3, 2012 | Excel Formulas | Essential Functions, Excel | Excel Beginner Lessons
Excel min In this post we are going to look at the min function (which finds the lowest value in a list) Please enable JavaScript LinkEmbedCopy and paste this HTML code into your webpage to embed. As always, here is a file you can practise with ...
by admin | Apr 30, 2012 | Excel Formulas | Essential Functions
How to add in Excel 2010 (and 2007) Please enable JavaScript LinkEmbedCopy and paste this HTML code into your webpage to embed. This post will show you how to sum in Excel (2007/2010). We will be using the Excel sum formula called...