Filtering Multiple Categories

[Bryz]

Hi all,

I have a question on how to filter by a single risk, if there is multiple risks in the cell. (Sorry I don't know how to explain it more clearly...)

I have attached the sheet I'm working on and highlighted the relevant cell. Hopefully it will help to explain what I'm asking.

Thank you in advance for your help!

Bryz

 

[Hui]

Bryz

Select the Drop Down arrow next to Related Risk heading
In the Search Box type something like *MBR* to search for any cells containing MBR

 

[json]

to build off of Hui, * is a wildcard character that represents multiple characters. I believe the ? is the wild card character for 1 single character.

 

[Bryz]

Hi Hui & Json,

Hui: By the drop down arrow do you mean the filter? Because I don't see a search box.
Json: Could you please explain that a bit more? I don't quite follow.

Thanks guys!

Bryz

 

[oldchippy]

Bryz,

The drop down arrow on "Related risks", then select "Text filters" and play around with those until you've found the right one

 

[Bryz]

Thanks oldchippy! That works fine!

 

[json]

Hi Hui & Json,

Hui: By the drop down arrow do you mean the filter? Because I don't see a search box.
Json: Could you please explain that a bit more? I don't quite follow.

Thanks guys!

Bryz

i originally had some examples, but i keep having issues with the "edit" button working... most of the time when i try to edit a post, my edits are not saved at all....

So lets pretend our data consists of names.
If i use B*, it would return any name that begins with "B". the * represents any number of chars so the lengths of the names can vary. Bob, Bill, Barry, Brenda, etc...
If i know their name started with a B and ended with an N, i could use B*n... Brandon or Ben could both be returned.
the * can be used if the lenth/number of characters doesnt matter or is not known...

but if we know that there are 4 chars in their name and it started with a C... i could use C???. Cara, Caty, Cici, etc... would all be returned. Cathy, Colleen, or Cid, would not because they do not meet the criteria of starting with C and followed by only 3 chars.
B?ll could trun Bill, Bell, Bull, etc...

what to use and how to use them (they can be used together (b*n??: could return Brenda or Breonah) all depends on your data.


i hope that helped some...??

 

[Bryz]

Yes that makes sense now. Thanks!