This Excel VBA function allows you to take a column of values (e.g. ID numbers) in one worksheet, and use that to get corresponding values that are in a second worksheet. If you understand SQL, it’s something like: SELECT b.country FROM idtable as a, countrytable as b WHERE a.id=b.id I’ll explain the scenario further with [...]
Continue reading...Tuesday, July 12, 2011
In MySQL, there are 5 different integer types, and each type allows for different integer value sizes. In addition, each type can be signed or unsigned. If your value is always positive, then you can make your integer type unsigned. The following are the values that different integer types (signed/unsigned) can hold: Integer Type Start [...]
Continue reading...Friday, July 2, 2010
I use the Apple bluetooth wireless keyboard, but I use it with my Windows computer, not a Mac. I love it though, and I think it’s the best bluetooth keyboard around – the problem is, while most keys generally work fine, certain keys are missing. For instance, on the Apple keyboard, the command key is [...]
Continue reading...Friday, January 22, 2010
Tweet This is a great plugin that allows you to have “Tweet This” buttons at the end of every post. Not only that, it also allows you to have Digg This, Facebook This, Plurk This, and many other kinds of buttons too. You get about 8 button designs as well, so you can find something [...]
Continue reading...Tuesday, January 19, 2010
Over December, I toured China for a month and saw some pretty interesting things there. And if there’s one thing that I’m thankful for, it’s a travel pillow because the time it takes to fly there can KILL (or land you with a very sore neck). The normal neck pillows don’t cut it too – [...]
Continue reading...
Tuesday, October 4, 2011
0 Comments