User Posts: Md. Abdullah Al Murad
VLOOKUP and COUNTIF are mostly used and powerful functions in MS Excel. VLOOKUP is used to find any specific data from any table and the COUNTIF function is ...
Today I will talk about MS Excel’s popular and highly used function name VLOOKUP. This function can be used to extract, compare, shift, or search data in any ...
MS Excel provides a simple function called MIN which returns a minimum value from any range. But there might be a case where we need to find or calculate a ...
MS Excel’s VLOOKUP function is used when we need to find things in a table or in a range by row. It makes our task easy in terms of searching for something in ...
MS Excel provides a few different sorting choices on top of the usual ascending and descending orders. We also have sorted by color or icon, as well as the ...
Sorting is the best way to make the dataset more convenient and acceptable. This makes our work with datasets in various ways. MS Excel provides different ways ...
To get used to less usage of the mouse there is no alternative to practicing keyboard shortcuts. In terms of copying formulas in MS Excel, there are lots of ...
At the time of working with numbers, we may need to find out or calculate the top 5, 10, or any specific percent in Excel. Generally, Excel provides various ...
In Microsoft Excel, there are a lot of ways to arrange text data alphabetically, dates chronologically, and numbers from smallest to largest or from highest to ...
When working in VBA, we often need to convert certain strings into lowercase, uppercase, or proper case strings. In this article, we will talk about lowercase ...
Data cleaning is an important part of data analysis. In Excel, TRIM is another most usable function in VBA code which removes extra spaces from the string or ...
The ISODD is one of the Excel information functions. It is a reference function that assists to show if a given number is odd or not. This article will share ...
For ignoring any type of calculation error, it is better to use exception handling. MS Excel provides an ISERROR function for this purpose. This function is ...
RIGHT is another popular function in MS Excel that is used to get the last character or characters in a text string, based on the specific number of ...
MS Excel provides us with various functions to help us customize the case of the text. Among them, the LOWER function is used to change the case of existing ...