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
The formula 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])
In the specific example of the video, it’s =IF(ISNUMBER(SEARCH($L$2,E2)),$L$2,”Not “&$L$2).