Al Arafat Siddique

We’ll use a bunch of URLs from the Exceldemy website to show how you can extract them. Method 1 - Create a User-Defined Function to Extract a ...

Knowing how to sort range using VBA in Excel saves time and effort in our daily calculations. Although Excel provides a sorting facility by default, using the ...

Method 1 - Remove the Negative Sign in Excel Using the ABS Function We have a list of numbers in cells B4:B10 with both positive and negative. In cell ...

The sample dataset contains sales data for 8 products that fall into 3 different categories. We will discuss 3 suitable methods to filter this dataset based on ...

We’ll first discuss how to write code in the Visual Basic Editor. Follow the simple steps to create the setup for writing your code. Steps: Go to the ...

The VBA And function in Excel is a logical function that allows us to perform a conditional check between two or more conditions. It returns true if all the ...

The VBA Right function in Excel returns a substring from within a string based on a specified location from the right to the left of that string. We can also ...

To illustrate how to refresh an Excel pivot table, we created two pivot tables for a dataset. The dataset shows a list of sale data with all required details ...

This article shows how to make an Amortization table in Excel that shows the periodic payments on a loan over a period of time. This table breaks down each ...

Method 1 - Using Excel Formula Excel lacks a built-in function to directly retrieve the sheet name, but we can create a formula using the MID, CELL, and ...

In this article, we’ll demonstrate how to count filtered data using the COUNTIF function together with the SUBTOTAL function. Download the Practice ...

Method 1 - Use of Relative Cell Reference in Formila in Excel  Steps: In cell F5, write the following formula to calculate the Price as a product of the ...

Example 1 - Copy Information Down the Cells Using xlFillCopy Dataset: In Column B, cells B4 and B5 contain numbers 1 and 2. The cells are also formatted with ...

This article illustrates how using Excel date shortcut makes dealing with dates in Excel easier. While making reports, budgets, calendars, and project ...

The VBA DateAdd function is under the date and time category of Excel’s VBA functions. By using this function we can add or subtract years, months, days, ...