Tagging Data in Excel

rjbinney

Active Member
Joined
Dec 20, 2010
Messages
253
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

Ambidextrous Undo
Undo last command with Ctrl+Z or Alt+Backspace. If you use the Undo icon in the QAT, open the drop-down arrow to undo up to 100 steps.

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
253
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,528
Messages
5,548,578
Members
410,853
Latest member
Tramp71
Top