Sulprobil

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

Donation Link

Sulprobil

Welcome to my English web site.

These webpages are published in the hope that they will be useful, but without any warranty; without even the implied warranty of merchantability or fitness for a particular purpose. Please read my disclaimer.

Bernd Plumhoff

New Topics:

[22-Feb-2010] MiniMax Interpolation
[20-Dec-2009] Transform long decimal numbers into binaries and vice
versa: LongDec2Bin
[19-Dec-2009] All cells of Range1 which are not in Range2: Rless
[19-Dec-2009] Create exactly a defined weighted random distribution
for a number of runs with ExactRandHistogrm
[12-Dec-2009] Obsolete functions: Countif, Rank and Sumif
[03-Dec-2009] Make rounded percentages sum up to 100% exactly
with the Largest Remainder approach
[05-Nov-2009] Generate correlated random numbers (Cholesky)
[29-Oct-2009] Generate non-repeating random integers with RandInt
[25-Oct-2009] Semi-obsolete functions: Offset, Sumproduct
[16-Oct-2009] Create random numbers with given mean and stdev
[06-Oct-2009] Create a random number with n decimal places
[30-Sep-2009] Return non-empty cells
[13-Sep-2009] Test for overlapping ranges
[12-Sep-2009] First or last weekday of a month (or of a year)
[31-Aug-2009] Ordinal numbers
[26-Aug-2009] D'Hondt method
[22-Aug-2009] Rounding numbers
[09-Aug-2009] Count string repetitions
[07-Aug-2009] Re-shape an array
[17-Jun-2009] Select rows conditionally and create a statistic like
count, min, max or sum of all entries or concatenate
them
[17-May-2009] Interpolate linearly
[25-Apr-2009] Wasting time with SUMPRODUCT?
[24-Apr-2009] Apply a function like MIN/MAX/SUM on given
strings/number combinations with Mfreq
[12-Apr-2009] Count unique entries
[02-Apr-2009] Poorest man's interpolation
[01-Apr-2009] Poor man's interpolation
[30-Mar-2009] Calculate fractions of months of date differences
[28-Mar-2009] Count trailing zeros of an integer
[25-Mar-2009] Concatenate attributes for combinations with Cfreq
[08-Mar-2009] Sum values for string/number combinations with Sfreq
[07-Mar-2009] Add values for repeating items with Afreq
[07-Mar-2009] Simple VBA sort function
[06-Mar-2009] List frequencies of value combinations with Pfreq

General areas:

[Sulprobil] [Get it done] [Family] [Contact] [Disclaimer]