In last week’s blog post I covered a complex formula to return unique random whole numbers. In this weeks’ post we will look at how we can convert that complex formula into a custom function.
Excel has three functions that can provide random numbers. But the random numbers created may not be unique random whole numbers. Here is one way to get a list of unique random whole numbers.
A few years back I posted a series of three posts about developing a formula to create a month calendar in Excel. I thought I would revisit that and convert that long formula into a custom function using LAMBDA.
When analysing data you may want to check for outliers. You can use MIN and MAX to get minimum and maximum values but you may want to average a certain number of top or bottom numbers. Here’s how you can do it.
Restarting Excel and Windows
Even now sometimes a full restart is a possible solution.
I recently had a macro returning a weird error message about an action taking too long. Restarting Excel did not fix it.
So, I restarted Windows and the macro worked as expected.
These days with so many apps running in the background, sometimes the only solution is a restart of Excel and Windows.
Turning it off and turning it on can still solve issues.