All articles with 'udf' Tag

Track Your Mutual Fund Portfolio using Excel [India Only]

Published on Dec 28, 2009 { 10 Comments }
Track Your Mutual Fund Portfolio using Excel [India Only]
Continue »

Get cell comments using Excel Formula

Published on Sep 3, 2009 { 12 Comments }
Get cell comments using Excel Formula
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 »

Networkingdays() an improved version of networkdays formula

Published on Jun 9, 2009 { 8 Comments }
Networkingdays() an improved version of networkdays formula
Continue »

Clean up Incorrectly Formatted Phone Numbers using Excel

Published on Sep 30, 2008 { 6 Comments }
Clean up Incorrectly Formatted Phone Numbers using Excel
Continue »

Handling spelling mistakes while searching your data using excel

Published on Sep 25, 2008 { 8 Comments }
Handling spelling mistakes while searching your data using excel
Continue »

Microcharting in Excel – 7 Alternatives Reviewed

Published on Sep 5, 2008 { 21 Comments }
Microcharting in Excel – 7 Alternatives Reviewed
Continue »

Conditionally play sounds when a cell value changes

Published on Aug 4, 2008 { 1 Comment }
Conditionally play sounds when a cell value changes
Continue »

Extract URLs from an excel spreadsheet cell using UDFs

Published on Jul 23, 2008 { 0 Comments }
Extract URLs from an excel spreadsheet cell using UDFs
Continue »

How to add a range of cells in excel – concat()

Published on May 28, 2008 { 53 Comments }
How to add a range of cells in excel – concat()
Continue »