All articles with 'if()' Tag

Highlighting Repeat Customers using Conditional Formatting [Part 2 of 2]

Published on Jan 6, 2010 { 8 Comments }
Highlighting Repeat Customers using Conditional Formatting [Part 2 of 2]
Continue »

Top X chart – Show Top X values of a chart Interactively

Published on Nov 12, 2009 { 3 Comments }
Top X chart – Show Top X values of a chart Interactively
Continue »

Baby Feeding Chart using Excel

Published on Oct 12, 2009 { 15 Comments }
Baby Feeding Chart using Excel
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 »

Create a number sequence for each change in a column in excel [Quick Tip]

Published on Jun 29, 2009 { 4 Comments }
Create a number sequence for each change in a column in excel [Quick Tip]
Continue »

Team To Do Lists – Project Tracking Tools using Excel [Part 2 of 6]

Published on Jun 25, 2009 { 16 Comments }
Team To Do Lists – Project Tracking Tools using Excel [Part 2 of 6]
Continue »

Array formula to check if a number is prime [just for fun]

Published on May 29, 2009 { 19 Comments }
Array formula to check if a number is prime [just for fun]
Continue »

Formula Debugging in Excel – Tip [spreadcheats]

Published on Dec 15, 2008 { 16 Comments }
Formula Debugging in Excel – Tip [spreadcheats]
Continue »

Advanced Data Validation Techniques in Excel [spreadcheats]

Published on Nov 25, 2008 { 21 Comments }
Advanced Data Validation Techniques in Excel [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 »