New Topics:

• [17-June-2009] Select rows conditionally and create a statistic on count, min, max or sum of all entries or concatenate them
• [17-May-2009] Interpolate linearly with optional constant extrapolation
• [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 value 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
• [28-Feb-2009] Show a number in a non-scientific format with all significant digits and all leading resp. trailing zeros: num2str
• [23-Jan-2009] What you should NOT do with Excel©
• [01-Jan-2009] Two things you should know about MS Word©
• [13-Dec-2008] Remember extreme results of a cell (watermarks)
• [21-Sep-2008] Return an array of non-empty cells
• [13-Jul-2008] Show a floating number with N significant digits

General areas:

• Organisation
• IT
• [Risk] Controlling
• HR
   
• Being developed:
  VBA Intro

My classics:

• Count hours per weekday
• Count unique entries
• Date functions
• Excel© Don’ts
• GetCell
• Interpolate
• List Frequencies
• MedianIf
• Multicat
• NSig significant digits
• Sorting (VBA or function)
• Spellnumber
• UniqRandInt
• VlookupAll