How to Use the LARGE Function in Excel
In this blog, Jonny explains how to use the LARGE Function to extract the top values in a row and even add them up.
How to Improve Your Excel Spreadsheets With Data Validation
Have you ever seen an Excel spreadsheet with a dropdown list in it and wondered how it was done?
This is data validation. Data validation improves the data in your spreadsheets. It makes reporting much easier as there is no risk of typos and no risk of an entry not fitting into your criteria.
In this blog we will take data validation a step further and look at how to make one drop-down list change its values depending on the choice made in a previous drop-down.
