Last week we set the After parameter for the Find method to distinguish which cell we wanted to start from. But it defaulted to go across the row. It can be set in order to go down the columns first using the SearchOrder parameter.

Power BI exercise focusing on JSON files using the NY Powerball data.

This week, I look at a simple method to convert a check box into a name (next time I will move up a gear!).

How to include error traps in our measure formulae.

Welcome back to our regular A to Z of Excel Functions blog. Today we look at the DBCS function.

Having stumbled upon the Find method last week, we’re going to lay fingers on some of the parameters. Last time we did the basic search looking for a simple string within a Range. Let’s go back to our worksheet last week: ...

Power BI exercise focusing on JSON files using the NY Powerball data.

This week, I look at what to do if you are short of memory.

Today we discuss proper practices we should adopt when creating measures.

On the final Friday of each month, we set an Excel problem for you to puzzle over for the weekend. On the Monday, we publish a solution. If you think there is an alternative answer, feel free to email us. We’ll feel free to ignore you.