Monthly Archives: July 2012

Substituting the list box with formula!

I was discussing with my colleagues last week, the ability of excel formula to solve most of the problems that we have in our pharma analytic lives. To an extent he agreed but was more of the opinion that “formula are good but most of the time I find myself writing macros as they are easy to implement”, while I was more of the opinion that formula are very creative, fast, better than macros many a times, and we should use macros only when necessary i.e. for doing things that formulas are not supposed to do—to be very honest I find more and more blogs about people trying to exploit formulas and make them do things that were never thought of; but lets not go into all this.

While we were discussing all this, he came up with a challenge for me. Continue reading