Recent Topics:

• [16-Aug-2010] Reconciliation: Compare two lists
• [11-Aug-2010] An optimised CumNorm function
• [03-Jun-2010] This web site has no broken links
• [27-May-2010] Find out which subset of values sums up to a
                        specified amount (accounts receivable problem).
• [20-May-2010] What is Value-at-Risk?
• [16-May-2010] Show the age of data with a Worksheet_Change event
• [15-May-2010] Excel VBA © Error Trapping
• [10-May-2010] Determine number of dimensions of an array (ArrayDim)
• [05-May-2010] Count colored cells with CountMyColor
• [25-Apr-2010] Excel © Forums and a comparison of 3 approaches
• [14-Apr-2010] Use the class SystemState to save and to restore your
                       system state variables to speed up your code
• [13-Apr-2010] Excel 2007 © VBA error message: "No RETURN() or
                       HALT() function found on macro sheet"
• [10-Apr-2009] Obsolete functions: Countif, Rank and Sumif
• [28-Feb-2010] Sulprobil Add-in for Excel © - 13 functions now
• [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
• [03-Dec-2009] Make rounded percentages sum up to 100% exactly
                       with the Largest Remainder approach
• [15-Nov-2009] Pricing Options with Excel VBA ©
• [05-Nov-2009] Generate correlated random numbers (Cholesky)
• [01-Nov-2009] Encapsulate a functionality with an Excel © UDF
• [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)