Copying the content of a cell if compared values match

Useful Excel formula when you need to get the value of a column if it exists in another column.

For example, say I need to get the DescriptionA of an IdA and if the Id exists on another list (IdB), copy the descriptionA to the descriptionB. 

=IF(COUNTIF($C$2:$C$9,A2)=0,"",VLOOKUP(A2,$C$2:$D$9,2,FALSE))

The quickest way would be a SQL sentence and extract the information straight from the DB tables.. but if all you had was the spreadsheet, this works quite well.

Simple Javascript

Change menu item text

Simple way of changing a list element without needing to find the nth child, element, relative, etc...

var item = $jq('.region_menus a[href="/hiya/home"]');
item.text("Find Food here");

And that is it!

IndexOf function Not valid on IE8

Array.prototype.indexOf = function(obj, start) {

     for (var i = (start || 0), j = this.length; i < j; i++) {

         if (this[i] === obj) { return i; }

     }

     return -1;

}

2013 Scrum - Team's achievements after adopting Scrum

Really happy with the results of our team since adopting Scrum. This is the summary for 2013:

The team has already changed and many new development plans for 2014. Hopefully it will only get better and better!