User Posts: Md. Abdullah Al Murad
0
How to Use VLOOKUP with COUNTIF (3 Ways)
0

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

0
How to Use VLOOKUP for Multiple Columns in Excel
0

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

0
Minimum Value Based on Multiple Criteria in Excel (7 Ways)
0

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

0
VLOOKUP Max of Multiple Values (With Alternative)
0

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
Random Sort in Excel (Formulas + VBA)
0

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
Sorting Columns in Excel While Keeping Rows Together
0

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

0
Shortcut to Copy Formula Down in Excel (7 Ways)
0

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

0
How to Calculate the Top 10 Percent in Excel (4 Ways)
0

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

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

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

0
How to Use LCase Function in VBA in Excel (With 4 Examples)
0

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 TRIM Function in VBA in Excel (Definition + VBA Code)
0

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 (With 4 Examples)
0

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)
0

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

0
How to Use RIGHT Function in Excel (With 6 Easy Examples)
0

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 LOWER Function in Excel (6 Easy Examples)
0

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

Browsing All Comments By: Md. Abdullah Al Murad
ExcelDemy
Logo