Tagging Data in Excel

[rjbinney]

I don't think "Smart Tags" are my answer here.

I have a column with lots of anecdotal data in it, and I would like to be able to sort it into various buckets. I can add columns for each "bucket", and either have it checked or not, but that seems like overkill. Is there a way to just add tags (like we do on this very board)?

For example:

Data	Tag
Sometimes when I get up in the morning, I like to have blueberry cake donuts. Sometimes, if I have the time, I like to have a bowl or two of Boo-Berry cereal. Sometimes I oversleep - and I just have to pick at whatever fresh berries are lying around the break room.	Breakfast; Blueberries; Mornings
What's the opposite of a vegetarian? A Meatatarian? A Baconairian? I can't stand fruits or vegetables - they come out of the ground! People walk on the ground. Dogs pee on the ground! Who would eat that? Bacon for breakfast, sausage for dinner, just like the Good Lord intended!	Breakfast; Dinner; Meat
Ugh. I am usually so hungover I can't even think about putting anything in my mouth before Noon. Mornings are "mommy time", as far as I'm concerned.	Mornings

<tbody>
</tbody>

So I could sort for "Breakfast" and get both quotes, "Mornings" would get the first and last, etc.

The best I can think of is:

Data	Blueberries	Breakfast	Dinner	Meat	Mornings
Sometimes when I get up in the morning, I like to have blueberry cake donuts. Sometimes, if I have the time, I like to have a bowl or two of Boo-Berry cereal. Sometimes I oversleep - and I just have to pick at whatever fresh berries are lying around the break room.	x	x			x
What's the opposite of a vegetarian? A Meatatarian? A Baconairian? I can't stand fruits or vegetables - they come out of the ground! People walk on the ground. Dogs pee on the ground! Who would eat that? Bacon for breakfast, sausage for dinner, just like the Good Lord intended!		x	x	x
Ugh. I am usually so hungover I can't even think about putting anything in my mouth before Noon. Mornings are "mommy time", as far as I'm concerned.					x

<tbody>
</tbody>

 

[DanteAmor]

In the tags you must put a short name, for example: "blueberr" to find "blueberries" or "blueberry"

Excel Workbook
	A	B	C	D	E	F
1		Blueberr	Break	Dinner	Meat	Morning
2	Sometimes when I get up in the morning, I like to have blueberry cake donuts. Sometimes, if I have the time, I like to have a bowl or two of Boo-Berry cereal. Sometimes I oversleep - and I just have to pick at whatever fresh berries are lying around the break room.	X	X			X
3	What's the opposite of a vegetarian? A Meatatarian? A Baconairian? I can't stand fruits or vegetables - they come out of the ground! People walk on the ground. Dogs pee on the ground! Who would eat that? Bacon for breakfast, sausage for dinner, just like the Good Lord intended!		X	X	X
4	Ugh. I am usually so hungover I can't even think about putting anything in my mouth before Noon. Mornings are "mommy time", as far as I'm concerned.					X
Hoja1

Formula in cell B2:

=IF(IFERROR(SEARCH("*"&B$1&"*",$A$2:$A$10),0)=0,"","X")

Copy to the right and down

 

[rjbinney]

Thanks. In another thread, trying to do something else, I learned this one:

[B][url=https://www.mrexcel.com/forum/excel-questions/1086782-concatenate-if.html]=TEXTJOIN(", ",1,INDEX(REPT(B$1:H$1,B2:H2="x"),0))[/url][/B]

 

[DanteAmor]

Ok, let me know if you need more information.