Tagging Data in Excel

rjbinney

Active Member
Joined
Dec 20, 2010
Messages
252
Office Version
  1. 365
Platform
  1. Windows
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:
DataTag
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:
DataBlueberriesBreakfastDinnerMeatMornings
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.xxx
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!xxx
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>
 

Some videos you may like

Excel Facts

Select all contiguous cells
Pressing Ctrl+* (asterisk) will select the "current region" - all contiguous cells in all directions.

DanteAmor

Well-known Member
Joined
Dec 3, 2018
Messages
12,593
Office Version
  1. 2007
Platform
  1. Windows
In the tags you must put a short name, for example: "blueberr" to find "blueberries" or "blueberry"


Excel Workbook
ABCDEF
1BlueberrBreakDinnerMeatMorning
2Sometimes 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.XXX
3What'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!XXX
4Ugh. 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

Active Member
Joined
Dec 20, 2010
Messages
252
Office Version
  1. 365
Platform
  1. Windows
Thanks. In another thread, trying to do something else, I learned this one:

Code:
[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

Well-known Member
Joined
Dec 3, 2018
Messages
12,593
Office Version
  1. 2007
Platform
  1. Windows
Ok, let me know if you need more information.
 

Watch MrExcel Video

Forum statistics

Threads
1,114,255
Messages
5,546,801
Members
410,759
Latest member
Bufnercash
Top