A reader contacted me asking how I displayed formulas on the squaring numbers post (see image below) and it got me thinking about adding this short post. I was asked whether I typed in the text in columns D and E from each formula manually or whether there was a quicker way and the answer was I Read More …

# Month: November 2016

## Formula to return the last value in a column

You may want to return the value from the last populated cell in a column for a number of reasons. Perhaps you have a dashboard which needs to return the ‘Current Champion’ but it needs to lookup against a dynamic list of champions so you can’t fix to one cell reference. In this example we Read More …

## Cascading data validation based on named ranges

When you fill in an online form it is quite common that a choice of drop down options will be dependant on one of your previous answers. In this post we’ll look at how you can replicate that in Excel. In this example, a firm has 8 offices across 3 different countries. When you Read More …

## Squaring numbers in Excel

You can use the POWER function to square a number, or set it to the power of any given value. These examples show how you can square or cube a number. If you wanted to find the square root of a number, use the SQRT function . E.g. =SQRT(81) will return 9.