“We seldom think of what we have, but always of what we lack.” [Arthur Schopenhauer]"

Excel Functions I would like to have

RoundToSum

RoundToSum to round values preserving their sum.

sbExactRandHistogrm

sbExactRandHistogrm to create random numbers with specified frequencies or relations (percentages).

sbRandGeneral

sbRandGeneral to create ‘General’ distributed random numbers.

sbTimeDiff

sbTimeDiff to calculate the time between two time points, but we just count specified time periods per weekday or per bank holiday - minus breaks.

Excel Functions which are finally available

TEXTJOIN

Join several cells with a given delimiter. I had implemented this with the user-defined function sbCat, and later with the user-defined function TEXTJOIN.

GROUPBY and PIVOTBY

The GROUPBY and the PIVOTBY functions allow you to group, aggregate, sort, and filter data based on the fields you specify. I developed something similar - in a rudimentary fashion - with sbMiniPivot.