• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Filtering Multiple Categories

B

Bryz

New Member
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
 

Attachments

  • Metric Library.xlsx
    13.5 KB · Views: 17
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
 
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.
 
Last edited:
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
 
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 said:
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
Click to expand...


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...??
 
You must log in or register to reply here.
Back
Top