Excel – using VLOOKUP to remove rows based on matching data from another column

Posted by Shek on December 10, 2012 under Misc | Be the First to Comment

In this post, I will demonstrate how to remove rows which are not matching the records in the other column of Excel with VLOOKUP. Although I am using Excel 2010 for the demonstration but this method should work with Excel 2003 as well.

Read more of this article »

Find and replace text for multiple files with notepad++

Posted by Shek on December 2, 2012 under Misc | Be the First to Comment

Being a web programmer, there are many times which I have to move files between the production and development environment and many setting parameters within the files has to be changed. Notepad++ has such a feature to find and replace text for multiple files

Read more of this article »