**“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 implementiert.

### 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.