I am a supporter ofSt. Joseph's hospice. If you find this site useful or if it helped you, consider a small donation toSt. Joseph's, please.
Information onSt. 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.
Calculate annuities of mortality tablesSimple charts can be created via characters in cells: cell based chartsCreate a list of unique identifiers and their frequency.Count Trailing ZerosUse COUNTIF to create a list of unique identifiersDate functionsShow cell formulas with GET.CELLMake rounded percentages sum up to exactly 100% with the Largest Remainder approachLock a formula so that it does not get adjusted to added or deleted cells.Some maybe controversial material on "obsolete" worksheet functions.Show numbers as ordinals such as 1st, 2nd, 3rd, etc.Test for overlapping rangesRounding numbersCalculate N significant digits of a numberSorting data automaticallyTest with MEDIAN whether a value is between two other onesCount or sum conditionally with potentially more than one condition with SUMPRODUCTA vacation planning tool can help you to organize your teams' holidays.