The site formerly known as Code For Excel and Outlook
October 26, 2008 by · 
While building a link list for my blogroll page (see Blogs I Read), I needed a way to create the list of links. The prospect of building all of the links by hand is pretty exhausting (yes, even the thought), so why not leverage Excel's capabilities?
Continue Reading: HTML Link Building Using Excel »
February 20, 2008 by · Here is an update to the code I have posted on the site at
Continue Reading: Format SSN – Updated formula »
January 28, 2008 by · This formula, entered as an array (Ctrl-Shift-Enter) in a single cell, will show you if there any duplicate entries in a given range (in this case, A1:C100). It is wrapped in an IF function to provide a friendly message; a kind of in-cell error handling, if you will. I usually do this when I know others are going to use the formula, to make it easy for them to understand the output. Otherwise it just gives you the number of unique entries which some people may not know what to do with.
Continue Reading: Counting Unique Occurrences in an Excel Spreadsheet »
Site last updated: February 9, 2012
Follow Me