Add, subtract, multiply or divide a set of values by another value, using ‘Paste Special’.
To add a reference line such as an average or benchmark to a horizontal bar chart.
Add a reference line, such as an average or benchmark, to a VERTICAL bar chart in Excel.
Excel’s IFERROR function traps errors that could be returned from a formula or calculation, and gives you control over what is returned instead of an error message.
Code to create a map in R Shiny using Leaflet. This example loads a base map, sets the centre and zoom, and has a reset button to return the map to the original view.
Sum the current value and all those that precede it in a column. This topic also shows how to fill cells down a column.
To test IF a value matches a condition, and return one result if TRUE, and another if FALSE.
Absolute and relative cell references, and ranges in Excel
Remove blank cells in a list of values in Excel using Advanced Filter, retaining the original list.