@ > Home > Contents by: Context - Chronology - Author

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/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/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)