All articles with 'countif()' Tag

Product Recommendation – Excel Lookup Toolbox

Published on Nov 5, 2009 { 3 Comments }
Product Recommendation – Excel Lookup Toolbox
Continue »

Prevent Duplicate Data Entry using Cell Validations

Published on Oct 26, 2009 { 13 Comments }
Prevent Duplicate Data Entry using Cell Validations
Continue »

Issue Trackers & Risk Management using Excel [Project Management using Excel - Part 5 of 6]

Published on Sep 8, 2009 { 16 Comments }
Issue Trackers & Risk Management using Excel [Project Management using Excel - Part 5 of 6]
Continue »

29 Excel Formula Tips for all Occasions [and proof that PHD readers truly rock]

Published on Aug 24, 2009 { 7 Comments }
29 Excel Formula Tips for all Occasions [and proof that PHD readers truly rock]
Continue »

Count the number of unique values in a range [Quick Tip]

Published on Aug 6, 2009 { 14 Comments }
Count the number of unique values in a range [Quick Tip]
Continue »

Generating invoice numbers using excel [reader questions]

Published on Jul 20, 2009 { 12 Comments }
Generating invoice numbers using excel [reader questions]
Continue »

Using Array Formulas in Excel – Find if a list has duplicate items

Published on Mar 25, 2009 { 21 Comments }
Using Array Formulas in Excel – Find if a list has duplicate items
Continue »

Advanced Data Validation Techniques in Excel [spreadcheats]

Published on Nov 25, 2008 { 21 Comments }
Advanced Data Validation Techniques in Excel [spreadcheats]
Continue »

Eight ways to exploit COUNTIF() … and sumif() too [spreadcheats]

Published on Nov 12, 2008 { 22 Comments }
Eight ways to exploit COUNTIF() … and sumif() too [spreadcheats]
Continue »

Learn Excel IF Formula – 5 Tricks you Didnt know

Published on Jun 9, 2008 { 41 Comments }
Learn Excel IF Formula – 5 Tricks you Didnt know
Continue »