xl-central.com, Your Quick Reference to Excel Solutions





navleft
navright
spacer
Recent Entries


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



spacer
Wu Yi Tea
Website Designed by Wu Yi Tea
Design downloaded from free website templates.
Wordpress Themes