A handy command for deleting that annoying .DS_Store file our good apple-lovers like to leave lying around on Windows share folders....

FOR /F "tokens=*" %G IN ('DIR /B /AH /S .DS_Store') DO ERASE /S /Q /AH  "%G"

If, like me, you attended last year's Google South Africa Developer conference then you'll be delighted to hear that the date for this year's event has just been launched!!

The event will be held in Johannesburg on the 2nd and 3rd November 2011 and promises to build on last year.

I'm hoping to find a Galaxy Tab under my seat ;-)

Hurry and register now!

Ran into a situation this afternoon whereby I needed to count the number of unique values in a column.

Since I find myself working in Excel, I went about searching for a solution to this.

AND... here you have it.. A quick and easy formula for working out the number of unique records in a column.

=SUM(IF(FREQUENCY(D2:D13824, D2:D13824)>0,1))

Have you ever registered yourself for a webinar only to miss it because you got the timing wrong?? Come on now, hands up all those who have...

Well, fear no more... Here's a link to a handy site which will help you with those pesky time zone conversion - click here
Have fun!