In this article, we will learn How To Find The Last Row in Microsoft Excel 2010. Scenario: In simple words, while working with long unmannered n...
In this article, we will learn about how to find the Maximum value if it matches multiple conditions in Excel. Scenario: When working with l...
In this article, you will learn how to filter the data based on the selection of cell. You need to follow the below steps: ...
In this article, you will learn how to extract the nth word from text string. We will use VBA code to create UDF to find the nth word in a string. ...
In this article, you will learn how to extract all text strings after a specific text. If there is a requirement to retrieve the data from a column...
In this article, we will learn How to Do Two Way Lookup In Microsoft Excel. Scenario: For instance, We need to find the value matched from t...
In this article, you will learn how to delete drop down list. The dropdown list is used to restrict the user to input data and gives the option to ...
The applications/code on this site are distributed as is and without warranties or liability. In no event shall the owner of the copyrights, or the authors of the applications/code be liable for any loss of profit, any problems or any damage resulting from the use or evaluation of the applications/code.