Excel Climate Change Infographic

This is an infographic based on our changing climate with statistics from the web showing the current state of affairs, all things climate change.

Tags Exce, Infographic, Climate Change, weath

Excel VBA Autofilter on Multiple Criteria

Anyone who has followed my posts on Ozgrid or Chandoo forum will have noticed how frequently I use the autofilter in favour of any kind of loop. I have been lead to believe that in some instances that arrays will perform faster than the humble autofilter however for brevity of code and swiftness I really like the simple elegance of the autofilter. In the article Autofilter on Multiple Conditions I delved into the world of the filer using more than one criteria.