IFERROR in Power QUERY
Power Query does not have an IFERROR function. It does however have another function that performs the same type of calculation.
(more…)Prefix Numbers Conditionally in Excel
Let’s say we need to put a prefix in front of a number to identify the period being used. Whether that be year, month or week. But we still need to use the number normally. Here’s one way to do that.
(more…)Automating bullet points in Excel
Some people like to use bullet points in text boxes. Here is a simple technique to insert bullet points based on a list of entries in an Excel sheet.
(more…)