Recent Entries

July 25, 2010
 Lookup the First Positive Number
April 24, 2010 Extract the Third Word from a Text String
March 15, 2010 Return the Workbook Path, Workbook Name, and Worksheet Name
March 15, 2010 Return the Workbook Path
March 15, 2010 Return the Workbook Name
March 15, 2010 Return the Worksheet Name
January 29, 2010 Extract Numeric Characters from a Text String
December 20, 2009 Count the Number of Words in a Text String
December 6, 2009 Extract the First Word from a Text String
December 6, 2009 Extract the Last Word from a Text String
November 7, 2009 Lookup a Value in a Filtered List
October 17, 2009 Lookup the Least Frequently Occurring Value
October 3, 2009 Lookup a Value across Multiple Sheets
September 6, 2009 Lookup the Last Non-Zero Value
August 25, 2009 Count based on a Single Criteria across Multiple Sheets
August 16, 2009 Sum based on a Single Criteria across Multiple Sheets
August 11, 2009 Average the Largest 3 Values from the Last 5 Values
July 22, 2009 Average the Largest 3 Values
June 3, 2009 Sum the Last 3 Values
June 2, 2009 Average the Last 3 Values
May 23, 2009 Lookup the Most Frequently Occurring Value
April 18, 2009 Consecutive Ranking
April 18, 2009 Unique Ranking
April 14, 2009 Sum the Largest 3 Values
April 8, 2009 Maximum based on Multiple Criteria
April 8, 2009 Minimum based on Multiple Criteria
April 5, 2009 Average based on Multiple Criteria
April 4, 2009 Average based on a Single Criteria
April 2, 2009 Maximum based on a Single Criteria
April 2, 2009 Minimum based on a Single Criteria
April 1, 2009 Count based on Multiple Criteria
April 1, 2009 Sum based on Multiple Criteria
March 31, 2009 Count based on a Single Criteria in a Filtered List
March 31, 2009 Sum based on a Single Criteria in a Filtered List
March 30, 2009 Average the Last 3 Non-Zero Values
March 30, 2009 Two Dimensional Lookup
March 29, 2009 Count Instances where X Occurs 10 Times in any Row
March 27, 2009 Lookup a Value based on Multiple Criteria
March 27, 2009 Lookup the Last Instance of a Value and Return the Corresponding Value
March 24, 2009 Count the Unique Values
March 24, 2009 Lookup the Closest Match
March 24, 2009 Lookup the Last Value Regardless of Data Type
March 24, 2009 Lookup the Last Text Value
March 24, 2009 Lookup the Last Numerical Value
March 24, 2009 Sum Every Second Row