MS Office - How to keep multiple instances with one as Default

I have came across the situation where I needed to have MS Office 2003 & 2007 both in my system, but that was very teasing that whenever I wanted to open my .xls files they automatically got opened in 2007 engine, although they work fine but some features behave abnormally when if you email these files to anyone who isn't having v2007 installed in his system. So I googled this issue of mine and found a very handy solution to that problem.

Click Start -> Run -> Type in the following command

"C:\Program Files\Microsoft Office\Office10\Excel.exe" /regserver

This is where my "Excel.exe" (v2003) file is placed you may alter this path as yours inside the quotation and then type /regserver at the end and press enter, It will load the necessary files of that version and next time whenever you wanna open files corresponding to that version they will automatically get opened in the engine that you register through this command.

VLookup for latest record

Dear Friends,

You must have noticed that the incredible VLOOKUP function of MS Excel always get you the result which occurs first in the given range if your range isn't consists of unique values. In that case, you either want to sort the data in descending order which isn't quite useful as several data structure can not afford to be sorted every time you use vlookup or you have to remove the earlier duplicated records in order to get the latest one with VLOOKUP.

Today, I am going to show you how to get the latest record through VLOOKUP by using it with another great function that is COUNTIF. That is how, you neither have to sort the data nor removal of earlier duplication would be required.

Separating Text and Numbers from an alpha-numeric String to separate columns

Friends, Many times you must have came across the situation where you have to separate numbers from the text or text from the numbers from the alpha-numeric string and these numbers or texts are not in the position where you could apply the great "text-to-column" approach as they neither possess fixed width nor separated by any thing and they are of various lengths.

Do you know that you can create your own functions in excel? Yes you can, just like SUM, MIN, MAX, TRIM, UPPER and many other functions. Today, We will use GetChars() function which will extract alphabets from an alpha-numeric string and GetNums()  which will get us only numbers.