I am a supporter of St. Joseph's hospice. If you find this site useful or if it helped you, consider a small donation to St. Joseph's, please.

Information on
St. Joseph's

 

You do not need to use macros each and every time when you like to solve a problem. Solutions based on worksheet functions can be fast, simple and easy to use.

Examples:

Create a list of unique identifiers and their frequency.
Count Trailing Zeros
Date functions
Show cell formulas with GET.CELL
Make rounded percentages sum up to exactly 100% with the Largest Remainder approach
Lock a formula so that it does not get adjusted to added or deleted cells.
Test for overlapping ranges
Rounding numbers
Calculate N significant digits of a number
Show numbers as ordinals such as 1st, 2nd, 3rd, etc.
Sorting data automatically
Test with MEDIAN whether a value is between two other ones
Count or sum conditionally with potentially more than one condition with SUMPRODUCT

Some maybe controversial material on "obsolete" worksheet functions.