Shakil Ahmed

We'll use a simple dataset to create a multi-selection drop-down. Method 1 - Making Multiple Selections from an Excel Drop-Down List with Duplicate ...

We have two simple examples. We need an automatically update the present date and we need to calculate the time remaining to the next Christmas. ...

We have a dataset of movies, their genres, leading actors, and years of release. We will provide the Genre and Actor name as criteria in a separate ...

We have a dataset of several people from different locations along with their vehicles. Using this data, we will form a list based on criteria. ...

Method 1 - Insert IF Statement with Direct Cell Reference to Create Drop-Down List In our example, we will select a sports category as Favorite Sports, and ...

In this article we will demonstrate how to use Excel's VALUE function to convert various types of data into numbers. Here is an overview: Before diving ...

In Excel, a drop down list is a helpful feature to swiftly fill in the right data in a field (cell or column). Once you build the drop-down list you will feel ...

In this article, we will demonstrate how to use the Excel VBA VLOOKUP in another worksheet. Suppose we have the dataset below, stored in the sheet called ...

In this tutorial, I am going to show you 8 quick tricks to use VLOOKUP to find duplicates in two columns. You can quickly use these methods even in large ...

Here we have a dataset of a few famous athletes from different sports. Using this dataset, we will find partial matches within two columns. How to ...

The sample dataset showcases the Addresses of Employees in a company. To check whether a a partial match for a given state name is in the Address ...

Dataset Overview We'll use the following dataset. It contains several Book Name along with their respective details. Method 1 - Use the COUNTIF for ...

Circumstances may demand a partial match with multiple values. Our agenda for today is to assist you in performing a partial match using VLOOKUP with multiple ...

Here we have a dataset of equipment lists for two gyms. We will compare the lists using the VLOOKUP function. Method 1 - Compare Two Lists in the ...

We have a table containing the roll of honor for the few major European football leagues. Using this dataset, we will VLOOKUP with two lookup values. ...