Good Tutorial on Excel Index and Match functions

http://www.randomwok.com/excel/how-to-use-index-match/

Very clear and easy to follow.

Popular posts from this blog

Make keyboard on PC behave like Mac

PC keyboard has Alt key next to Space key while on Mac you have Command key next to it. On Mac you would do Command+Space to change language and Command+C, Command+V for Copy and Paste respectively. The easy and clean way to make PC keyboard having this behaviour is by using the free AutoHotKey tool. With the tool installed, you would create an .ahk file and run it to map the key combinations according to the content in the file. In my case, this is what I put in .ahk file !c::Send, ^c !v::Send, ^v !space UP::Send #{Space} Return !c is Alt+C which I will send ^c or Ctrl+C. The # is Windows key
Read more

Scuttle Bookmark

Check this out. I just downloaded this and implement social bookmarking on my site. The download page is here http://sourceforge.net/projects/scuttle/ To make it work on my local developing maching (windows xp/iis/mysql/php5), I had to enable the multibyte string module (php_mbstring.dll) and also did one modification in functions.inc.php line 8 : original : T_setlocale(LC_MESSAGES, $locale); changed to : $ret = T_setlocale(LC_ALL, $locale); This is because the LC_MESSAGES is not supported in my installed PHP. If needed it has to be compiled using something I don't remember but you can check the documentation. It's there. Hopefully one day I will have time to develop an extended version of the scuttle to be the my ideal online bookmark with the following features: 1. can import bookmarks from browser, add bookmarks to the web and being able to export back into browser keeping the folder structures intact. 2. to do that each bookmark will have to include both categories and t
Read more

DVI Pin 14 is shorter than others

Image
I've been wondering about this and wanting to check this out. Wiki clearly clarified this for me. Note also that on the male DVI connector, pin 14 (+5 volts) is shorter than the other pins. This is intended to ensure that this is the last contact to mate when inserting a plug.
Read more