There are times when the right kind of information evades you, and that could cost you very dear, but there are other times when you never had the intention, yet you stumble upon gold mines!

Below is a list of all the various useful references & links that I’ve stumbled upon!

References:

  • Excel Formulae

http://www.cpearson.com/excel/ArrayFormulas.aspx
http://www.emailoffice.com/excel/arrays-bobumlas.html – Check out the Calendar example here
http://www.dailydoseofexcel.com/archives/2004/04/05/anatomy-of-an-array-formula/ – Post-mortem analysis on an Array Formula

http://stackoverflow.com/questions/350264/how-can-i-perform-a-reverse-string-search-in-excel-without-using-vba” target=”_blank

http://www.cpearson.com/excel/CollectionsAndDictionaries.htm

  • Sites to bookmark

http://www.cpearson.com/ – C. Pearson’s Blog
http://www.techonthenet.com/excel/index.php – Complete Guide to Excel & VBA

Advertisements