Have you ever felt that if you could have that operation automated in MS Excel that you have always been doing manually? Do you have any operation that you do a lot but there is no automatic function / feature available in Excel?

If the above is right then you MUST mention that operation / feature-you-want-in-Excel here. I am trying to write down an Add-in for Excel. But for that I want to add those features which are most commonly used and would help a lot of people.

So, go ahead and leave behind as many would-be-features here. If I like your suggestion / idea, I will contact you back to understand the suggestion / idea better and I may take that idea up and write an Add-in about.

I have been using Excel to perform all my stock market record-keeping and stock-tracking activities. I use it to daily get the stock numbers using the external data functionality to know what my daily gains and losses have been. Lately I tried adding another functionality to it and during that I came across a need to use a function that helps create Hyperlinks to web pages. For this I used Hyperlink() function.

Auto fill is the ability of Excel to identify and fill a series of text or numbers, automatically, in a given range. For example, you want to fill down a row, a series of numbers from 1 to 10. There are 2 ways to do it:

One is that you type these numbers manually yourself. This method is fine, if in this case, as there are only 10 numbers to be manually-punched. But what if the series to be filled was 1 to 1,000? …or 10,000?

Match function is used to get the relative location of a text or value within a specified array.

Syntax:

= Match (Lookup_value, Lookup_array, Lookup_type)

Lookup_value: This value in the function specifies the value or the text (an item) that is to be looked up in the array (or a range of cells)