In this article, we will use the VLOOKUP function with the COUNTIF function in Excel. VLOOKUP and COUNTIF are mostly used and powerful functions in MS Excel. ...
Today I will talk about MS Excel’s popular and highly used function named the VLOOKUP function. This function can be used to extract, compare, shift, or search ...
In this tutorial, I am going to show you 7 easy ways to find minimum value based on multiple criteria in Excel. MS Excel provides a simple function called MIN ...
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 ...
In this article, we will show how to sort by column in Excel while keeping rows together. Sorting is the best way to make the dataset more convenient and ...
To get used to less usage of the mouse there is no alternative to practicing keyboard shortcuts. Sometimes it might seem difficult to copy formula down with ...
When 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 methods for ...
In this article, we will show how to sort multiple columns in Excel independently of each other. In Microsoft Excel, there are a lot of ways to arrange text ...
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 ...
If you are looking for how to use the ISERROR function in Excel then you are in the right place. For ignoring any type of calculation error, it is better to ...
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 ...