2009/08/29 5072 List of combinations from a set of
entries

2009/08/28 5071 Fill gaps in data

2008/11/25 5070 Array formula within Data Validition

2008/03/25 5069 {End}{Arrow}-like range in a formula

2008/03/05 5068 VBA Routines (I): Objects

2008/01/27 5067 Counting unique items between 2
columns

2008/01/18 5066 SUMIF with a list as criteria

2007/12/22 5065 SUBSTITUTE depending on country

2007/12/20 5064 Workaround for the DATEDIF function

2007/12/07 5063 Convert column entries into row cells,
depending on key

2007/12/04 5062 x-th and x-last working day

2007/11/21 5061 Convert String to Number

2007/11/21 5060 MATCH in an array, returning row+column

2007/11/01 5059 Get included VAT-Amount

2007/10/05 5058 Use 1 instead of 2 interval boundaries

2007/09/27 5057 Service charge (step function)

2007/09/19 5056 Count letters in a cell

2007/09/17 5055 Use Chart trend line formula as cell formula

2007/09/12 5054 Why MATCH is more efficient than VLOOKUP

2007/09/10 5053 Calculate Lookup inside
IF(ISERROR(VLOOKUP( once only

2007/09/10 5052 Copy an EXCEL range into a VBA variable directly

2007/08/29 5051 No decimal separator if #,##0.??? is an integer

2007/08/23 5050 Count of Saturdays in August 1999

2007/07/25 5049 Print Labels without MS Word

2007/06/28 5048 Search and replace characters like CR

2007/06/28 5047 Conditional Formatting

2007/06/28 5046 Convert IP-Address (IP4) between String, Number and Hex

2007/06/22 5045 Binary Replace of leading fillers (instead of sequential)

2007/06/20 5044 Turn array with empty fields into a consecutive column

2007/06/18 5043 Split string formula into sub strings of variable length

2007/05/29 5042 Select an extreme record, decided by subordinate criteria

2007/04/19 5041 Sum of the last valid x entries

2007/04/19 5040 Arriving Friday 13. ...

2007/03/21 5039 Print or fax bank transfers (Germany)

2007/03/18 5038 DSUM: old but not weak

2007/03/13 5037 Adding parts of a row by parameters

2007/02/27 5036 VBA function with range type argument

2007/02/07 5035 Keyboard overlay for printouts

2007/02/02 5034 Permanent sort of next birthdays

2007/01/29 5033 Conversion between score types

2007/01/29 5032 Hierarchical validities

2007/01/20 5031 Copy (or: clone) formulae identically as "Cut" does

2007/01/17 5030 Calendar weeks CW of a month

2007/01/15 5029 Project planning

2006/12/15 5028 Time constants, like 1 month = 30.436875 days

2006/12/15 5027 Simple German payroll application (for free)

2006/12/01 5026 Multiple SUBSTITUTE(): The Paper-Stone-Scissors-Relation

2006/11/30 5025 Save chart as .PNG

2006/11/26 5024 Column chart with variable width (histogram)

2006/11/25 5023 Get short concatenated linear and exponential functions

2006/11/25 5022 Very short concatenated linear functions via MIN and MAX

2006/11/24 5021 Transparent chart on a cm² grid

2006/11/12 5020 Splitting a duration into fixed periods

2006/11/12 5019 School - week tables of resources

2006/11/12 5018 Date and time entries w/o delimiters

2006/11/09 5017 Convert to Date, typed in as 14/03/

2006/11/08 5016 Fit a calendar into 256 columns

2006/11/03 5015 Include Non-Alert-VBA into shipped files

2006/11/02 5014 Calculate hours without days

2006/11/02 5013 Conditional cell protection

2006/10/15 5012 Time-Clock with multiple come-leave (Gantt chart)

2006/10/15 5011 Turn 2 or 3 dimensions into 1

2006/10/15 5010 Inserted/deleted row breaks formula

2006/10/15 5009 A Shorter Next Month Formula

2006/10/15 5008 VLOOKUP speeded up by cutting range

2006/10/15 5007 Upper limit VLOOKUP

2006/10/15 5006 Worksheet design

2006/10/15 5005 Formula philosophy

2006/10/15 5004 If not a workday: Next (or previous) workday

2006/10/15 5003 Assigning weekly values to months

2006/10/15 5002 Change small list to multi column

2006/10/15 5001 Storing And Retrieving Formula Expressions
(SETV,GETV)