Md. Abdullah Al Murad

Method 1 - Combining the VLOOKUP and the MAX Functions to Find the Max of Multiple Values This is the sample dataset. Steps: Enter the following ...

We will show 6 easy methods to random sort in Excel, using a dataset of a shop containing product Name, Quantity, Delivery Date, and Price. Method 1 ...

Method 1 - Using the Sort Command to Sort by Column and Keep Rows Together Select the cells in the range D5:D10. Go to the Data tab. From the Sort ...

Method 1 - Using Keyboard Shortcut to Copy Formula Down for a Column in Excel Steps: Choose a cell (D7) and press CTRL+SHIFT+END to select all the cells ...

Method 1 - Using Conditional Formatting to Calculate and Highlight the Top 10 Percent of Values  Steps: Here's a dataset of salespersons with their ID, ...

We have a dataset of fruits with their delivery information and quantities. We are going to sort those columns independently. Method 1 - Using VBA ...

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

This is an overview. The VBA TRIM Function Summary The Trim function in VBA removes the leading and trailing spaces from a supplied text ...

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

Method 1 - Using RIGHT Function to Get a Substring Until Space Step 1: Write down the below formula in cell C5. =RIGHT(B5,LEN(B5)-SEARCH(" ",B5)) ...

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

This an overview of the LEN function.   Syntax The LEN function is described with the following syntax: =LEN (text) ...

Excel is extremely powerful for large calculations and formulas. When working with formulas, sometimes, we need to copy formula to change only one cell ...

Overview of Excel LARGE Function In the following picture, you can see the overview of the LARGE function. Summary The LARGE function returns ...