All articles with 'array formulas' 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 »

Christmas Gift List – Set your budget and track gifts using Excel

Published on Dec 7, 2009 { 10 Comments }
Christmas Gift List – Set your budget and track gifts using Excel
Continue »

Product Recommendation – Excel Lookup Toolbox

Published on Nov 5, 2009 { 3 Comments }
Product Recommendation – Excel Lookup Toolbox
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 »

Twitter Formula Contest – We are 5000 strong now

Published on Aug 3, 2009 { 15 Comments }
Twitter Formula Contest – We are 5000 strong now
Continue »

Sumif with multiple conditions [quick tip]

Published on Jul 22, 2009 { 27 Comments }
Sumif with multiple conditions [quick tip]
Continue »

How to Round and Sort Data using Excel Formulas?

Published on Jul 6, 2009 { 20 Comments }
How to Round and Sort Data using Excel Formulas?
Continue »

Statistical Distributions in Excel [spreadcheats]

Published on Jun 1, 2009 { 6 Comments }
Statistical Distributions in Excel [spreadcheats]
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 »

Excel Links – Dilbert is Recession-proof Edition

Published on May 25, 2009 { 5 Comments }
Excel Links – Dilbert is Recession-proof Edition
Continue »

Excel Tips Submitted by You [Part 2]

Published on May 12, 2009 { 3 Comments }
Excel Tips Submitted by You [Part 2]
Continue »

Excel Tips Submitted by You [Part 1]

Published on May 11, 2009 { 5 Comments }
Excel Tips Submitted by You [Part 1]
Continue »

Analyzing Search Keywords using Excel : Array Formulas in Real Life

Published on Apr 29, 2009 { 4 Comments }
Analyzing Search Keywords using Excel : Array Formulas in Real Life
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 »