Wednesday, December 15, 2010

Deleting a branch on Github

If you need to delete a branch you have created on github or any ohter remote git repository, heres how to do it.

Sunday, December 12, 2010

Excel tricks

First guest tip, from my colleague Jonathan Luker:

If you nest a MATCH() function inside a ISNA() function, it can make a column of TRUE or FALSE on the new data.

e.g. if I look for matches in ItemID between data in separate tabs:
=ISNA(MATCH(A2, 'Test-jul data'!$A$2:$A$15633, FALSE))
This will scan the list for matching ItemsIDs and put TRUE or FALSE in the cell beside each one.
Copy & paste for full list (takes a while to process of course!).

If you sort on that TRUE or FALSE column, you'll have all the new ones listed together.

There are a bunch of IS functions in Excel:
# Excel ISBLANK Function
# Excel ISERR Function
# Excel ISERROR Function
# Excel ISLOGICAL Function
# Excel ISNA Function
# Excel ISNONTEXT Function
# Excel ISNUMBER Function
# Excel ISREF Function
# Excel ISTEXT Function
Quite handy, especially when used with IF(), MATCH(), VLOOKUP(), etc.


Friday, December 10, 2010

Ubuntu

So, after buying a new HDD, comes the re-install of Ubuntu 10.04.
So far:

How to get back the kill X server key combo (in case of emergencys with complete X lockup)

Disable 3D desktop effects to get rid of annoying background flashing when playing flash videos in browser in full-screen.

To move the Gnome panels around, you first have to untick "Expand" in their properties and then you can drag&drop them where ever you like using std mouse left-click&drag.