Excel Formulas Tutorials

Matching Multiple Items

Wednesday, October 22nd, 2008 at 03:58 | 2 comments
Categories: Formulas

Excel Creating Unique Identifiers

Monday, October 20th, 2008 at 14:06 | 6 comments
Categories: Formulas

Substitution of Strings

Sunday, October 19th, 2008 at 16:09 | 0 comments
Categories: Formulas

How to Add a Comment to a Formula

Wednesday, October 15th, 2008 at 02:08 | 6 comments
Categories: Data, Formulas, General

Comparing Items in a List

Tuesday, October 14th, 2008 at 02:57 | 1 comment
Categories: Formulas

VBA: UDF to perform a 3-parameter Vlookup

Saturday, October 4th, 2008 at 10:36 | 5 comments
Categories: LOOKUP, VBA

Advanced Dynamic Ranges

Saturday, October 4th, 2008 at 10:32 | 1 comment
Categories: Formulas

Sum by Color

Saturday, October 4th, 2008 at 10:29 | 1 comment
Categories: Formulas
Tags: , ,

VBA and Vlookup: Find occurence of string

Tuesday, September 30th, 2008 at 14:40 | 2 comments
Categories: LOOKUP, VBA

Averaging Non-Zero Values

Friday, September 26th, 2008 at 11:00 | 0 comments
Categories: Formulas