User Posts: Md. Abdullah Al Murad
0

## How to Use VLOOKUP with COUNTIF (3 Easy Ways)

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. ...

0

## How to Use VLOOKUP for Multiple Columns in Excel (6 Examples)

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 ...

0

## How to Find Minimum Value Based on Multiple Criteria in Excel

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 ...

0

## Find Max of Multiple Values by Using VLOOKUP Function in Excel

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 ...

0

## How to Perform Random Sort in Excel (6 Easy Methods)

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 ...

0

## How to Sort by Column in Excel to Keep Rows Together

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 ...

0

## How to Copy Formula Down with Shortcut in Excel

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 ...

0

## How to Calculate Top 10 Percent in Excel (4 Easy Ways)

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 ...

0

## How to Sort Multiple Columns in Excel Independently of Each Other

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 ...

0

## How to Use VBA LCase Function in Excel (3 Easy Examples)

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 ...

0

## How to Use VBA Trim Function in Excel (5 Practical Examples)

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 ...

0

## How to Use ISODD Function in Excel (4 Suitable Examples)

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 ...

0

## How to Use ISERROR Function in Excel (with 5 Examples)

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 ...

0

## How to Use RIGHT Function in Excel (6 Suitable Examples)

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 ...

0

## How to Use Excel LOWER Function (5 Suitable Examples)

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 ...