The CELL function in Excel is very powerful and relatively unknown to many. Use the Excel CELL function to return information about a cell. This can include the cell’s number format, row number or whether it is locked or protected.
There are times when this kind of functionality becomes extremely useful. Especially while Excel does not provide many other means of finding the number format of a cell, or whether it has been locked.
[Read more…] about Excel CELL Function – Return Cell InformationDue to popular demand, I have created an Excel fixture and league table generator.
Following on from my fixture list creator and league table generator files, I was asked to create a combined file to create a fixture list and also generate a league table from results entered.
Download the Excel fixtures and league table generator.
To use the file;
An interesting question came up during one of my consultancy visits last week. They needed to find the top 5 values in a list based on multiple criteria. They then also needed the name of the company achieving that value.
[Read more…] about Find the 2nd Largest Value Using Multiple CriteriaIf you collect email addresses in your spreadsheet. You may want to validate an email address in Excel.
Using Data Validation you can check the syntax of an email address to ensure it is legitimate. It cannot check the existence of an address, or who it belongs to. But it will ensure the existence of the @ symbol, a period (.) and no spaces in the address.
[Read more…] about Validate an Email Address in ExcelThe TRUNC function in Excel is used to reduce the number of decimal places on a number without rounding.
Excel provides a few different rounding functions such as ROUND, ROUNDDOWN and CEILING to cater for all your rounding needs. However the beauty of the TRUNC function is that you can set the number of decimal points for a number without rounding.
Truncating numbers in this way will affect the number and therefore impact on calculations that rely on this number. Using the Excel formatting tools to reduce the number of decimal places is another alternative that does not affect the number involved.
[Read more…] about How to use the TRUNC Function in Excel
