One of the most basic Excel function new users learn along with SUM, COUNT and MIN is the MAX function. However, in previous Excel years- 2003 and earlier, you had to actually type the MAX...
Recent Posts
Welcome again to Formula Friday, your pre weekend dose of Excel Formulaness. Ok so today we will look at the very basics of using the IF formula in particular how to check if one number is greater...
Excel Tip: Export More Than 65000 Lines From MS Access to MS Excel
This is a problem that I have asked about many times. From Excel 2007 onwards the capacity of Excel Rows is waaaaay more than previous versions (in fact it is 1,048,576!). So, why is...