Do not spoil what you have by desiring what you have not; remember that what you now have was once among the things you only hoped for.
Epicurus – Greek philosopher
Monthly Archives: April 2023
Excel Custom Function to Return Unique Random Whole Numbers
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.
One can resist the invasion of armies; one cannot resist the invasion of ideas.
Victor Hugo
Unique Random Whole Numbers in Excel
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.
The greatest challenge to any thinker is stating the problem in a way that will allow a solution.
Bertrand Russell
Custom Calendar Function in Excel
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.
You can’t use up creativity, the more you use the more you have.
Maya Angelou
Average Top and Bottom Values in Excel
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.