How to sort by multiple keywords?

[OldGrantonian]

I have Excel 2007 in Win 7.

I'm wondering if it's possible to sort data by a column that contains several keywords.

For example, here is an example of an "SR" (system requirement):

• Log all emails that are sent when Administrator opens a list.

The entry in the "Keywords" column would be:

• log, email, open, list

So, if the developer wants to group all the SRs related to emails, she would like to sort only by "email" - and ignore all the other keywords. But if she wants to group all the SRs related to logging, she would like to sort by "log", and so on.

Each SR has a minimum of 1 keyword and a maximum (at the moment) of 4. There's a total of about 10 different keywords.

[Fotis1991]

Welcome to the Forum, unfortunately:

This is a duplicate post and as such does not comply with Rule 5 of our forum rules. This thread will now be closed, you may continue in your other thread.

Thread Closed.