Sourav Kundu
Tags are often used in Excel and are very useful for maneuvering data. They save time and are very efficient. In this article, we will show you how you can add Tags for a dataset.
Download Practice Workbook
You can download and practice from this workbook.
2 Easy Ways to Add Tags in Excel
There are many types of tags used for different purposes. We are going to use the Combination of IF, ISNUMBER, and SEARCH functions and use the Filter feature to add tags in the Excel file.
1. Use of Functions to Tags
In this method, we are going to see the way of adding tags into Excel using a formula combining different Excel functions. Before proceeding to the method, let’s get to know the dataset we are going to use for the article. We have prepared a dataset consisting of Movie names and their Genre.
We will have a Result and Tag column.
Upon inserting any Genre name in the Tag cell, the Result column will give output.
- First, insert any Genre name. We chose Drama.
- Now, write the following formula in D5 and press ENTER.
=IF(ISNUMBER(SEARCH($E$5,C5)),$E$5,"Not "&$E$5)Here, the SEARCH function searches the tag name within the desired cell. And when finds that the function returns a number. ISNUMBER checks whether there is a number or not, and the IF function performs the rest of the task of adding the appropriate result.
So, we can see that the first movie is Not Drama.
- Now, Hold and Drag the D5 cell downward.
By doing so we get results for all other movies.
Again, change the tag name. And see, we have got a column of results indicating which movie is a thriller and which is not
Read More: How to Add Tag to Properties in Excel (with Easy Steps)
2. Use of Excel Filter to Add Tags
We can add tags using the Filter feature. Let’s try this easy trick of Excel to perform the task. We have the same dataset.
- First, select the data table
- Then, go to the Editing bar. And select the Filter option from the Sort & Filter tab.
So, you will see some bars on both columns.
- Now select the Genre bar
A window similar to this will open.
- Write a specific Genre in the Text Filters box and press OK.
Thus, the Filter feature will show us records with the Genre name.
Read More: How to Filter Tags in Excel (2 Quick Approaches)
Practice Section
We have provided a workbook in the Download section. You can download the workbook and apply these methods yourself.
Conclusion
That’s all for the article. We’ve tried to demonstrate a couple of easy ways to tag in Excel. Now you know how to tag in Excel. We hope you find this article useful. If there are any further queries or recommendations, feel free to comment.
