by Fiona Hannon | Oct 17, 2013 | Blog, Excel Formulas, Excel Formulas, Excel Tips, Uncategorized
Let’s take a look at the following really useful functions that will help us every day in Excel. Functions that help with CASE This set of 3 functions are very handy to use when text has been imported into Excel and it has not arrived in the correct case. Maybe... by Fiona Hannon | Oct 17, 2013 | Blog, Excel Formulas, Excel Formulas, Excel Tips, Uncategorized
Let’s look at a scenario where data is given to you in .CSV format or already has been imported into Excel for you. It may be the case that you have a list of ID numbers, when they are pasted or imported into Excel, the leading Zero which was there in the... by Eoin Lynch | Oct 16, 2013 | Blog, Excel Formulas, Excel Tips
In this example we cannot use the function Min (Minimum), because it will only find the smallest value in a range of cells. However the Small Function allows you to choose the Smallest and also the second smallest, third smallest and so on. The challenge with the...