In this article, we will learn how to filter the data and then how we can give the different criteria for filtration by using the VBA in Microsoft Excel 2007 and later version. How to put the filter in data? … Continue reading →
In this article, we are going to learn how to create user defined functions in Microsoft Excel by using the VBA. User Defined Function:- Microsoft Excel is already having lot of functions, but still everybody has different requirements, situation, we … Continue reading →
In this article, we are going to learn how to use comment option in Microsoft Excel through VBA. Comment is the source by which we can convey the message to every user if it is required to provide information about … Continue reading →
In case you have a requirement on combining multiple columns to on column & you did not have a clue then this whole article is for you. In this article we are going to learn how to combine multiple columns … Continue reading →
In excel if you every come across a scenario in which you do not want the other user from entering space before text then this article is for you. Question): I would like excel to pop up an alert … Continue reading →
In this article, we will discuss how we can identify unique numbers in Microsoft Excel using formulas. There can be various scenarios. However, we will cover the common problems that users usually face in their daily work. The problems can … Continue reading →
In this article, we will focus on how to use SUMPRODUCT function with criteria in 2 columns & extract the output, meeting all the conditions. Question):- I have a three columns data comprising of Months in column A, Sales Rep … Continue reading →
In this article, you will learn how to increase the size of the selected cell that contains data validation. If you are working on a report that contains too much information & there is shortage of space, the cells that … Continue reading →
In Excel, while preparing reports for boss/management, we tend to insert comments in order to let the other person inform the status of the task. Comments are basically used for internal purpose. In this article, we will learn how to … Continue reading →
In case you want to learn Excel IF function then this article is for you. In this article, we will focus on describing the use of IF function in multiple conditions. IF function use to check the specified condition is … Continue reading →
