This post explains how you can make your own functions in Excel without VBA. Suppose you have a spreadsheet like this: Ugh! That is an ugly formula! Wouldn’t it be nicer if we could write something like =getCity(A2)? Of course, we could make a user-defined function (UDF) with VBA. VBA is powerful enough to create functions, […]
Blog: Contextures on spreadsheet smells
Debra Dalgleish of Contextures, a well-known Excel blog, wrote a post on my ICSE 2012 paper today.
