Implement tags in Excel in seconds

Have you ever wanted to use tags in Excel?

Maybe you want to assign tags in Excel for your business contacts, friends, or favorite recipes.

You may have many different tags, frequently create new ones, and an arbitrary amount of tags assigned to each individual.

It’s extremely easy to do this using filters and Excel's search functionality. It only takes a few seconds.

You may also want to do this using formulas, to update dynamically, or output different information depending on whether a certain tag is present.

That’s a bit more complicated, but I walk you through how to do it in the video.

Links and Resources:

Filters: Excel's Easy Button - https://rockstarexcel.com/filters-excels-easy-button/
How to Use the & Function - https://rockstarexcel.com/never-use-concatenate-use-instead/
Rockstar Excel website: https://rockstarexcel.com/
Book a free consultation to learn how we can save you time and money: https://rockstarexcel.com/book-a-free-discovery-session/
Sign up for our newsletter for free Excel tips in your inbox: https://rockstarexcel.com/newsletter/

General formula for searching for tags in Excel: =IF(ISNUMBER(SEARCH([the tag or reference to the tag you’re looking for],[the cell where tags are listed])),[output if the tag is found],[output if the tag is not found])

Formula used in the example in the video: =IF(ISNUMBER(SEARCH($L$2,E2)),$L$2,”Not “&$L$2)

Видео Implement tags in Excel in seconds канала Rockstar Excel