Filtering
 

I have a spreadsheet which has filters at the top.

In column A there are lists of activities. Sometimes there are multiple
assigned to an activity. To explain it simply, for example:

Col A Col F (Person assigned)
Activity 1 Rich
Activity 2 Dan, Rich
Activity 3 Rich, Dan

I want to be able to sort and list all activities that Rich is involved in
but the filter can only do all Dan, Rich and then all Rich somewhere else etc.

Can I do this using filters and can you also suggest a worksheet function to
do this e.g. using the match funtion?

Thanks!

David

Dave,

Filter works on the full contents of the cell.

One solution:
Set up columns for individual names then in each column enter
=IF(NOT(ISERROR(FIND("Rich",F2))),"Y","")
changing the name to match the column name.
If the name appears anywhere in cell F2, the formula will return 'Y'
otherwise NULL.
Copy down each column - Job done.

HTH

"Dave" wrote:

I have a spreadsheet which has filters at the top.

In column A there are lists of activities. Sometimes there are multiple
assigned to an activity. To explain it simply, for example:

Col A Col F (Person assigned)
Activity 1 Rich
Activity 2 Dan, Rich
Activity 3 Rich, Dan

I want to be able to sort and list all activities that Rich is involved in
but the filter can only do all Dan, Rich and then all Rich somewhere else etc.

Can I do this using filters and can you also suggest a worksheet function to
do this e.g. using the match funtion?

Thanks!

David

Couldn't you use the custom filter and show rows where col F "contains" Rich?

"Dave" wrote:

I have a spreadsheet which has filters at the top.

In column A there are lists of activities. Sometimes there are multiple
assigned to an activity. To explain it simply, for example:

Col A Col F (Person assigned)
Activity 1 Rich
Activity 2 Dan, Rich
Activity 3 Rich, Dan

I want to be able to sort and list all activities that Rich is involved in
but the filter can only do all Dan, Rich and then all Rich somewhere else etc.

Can I do this using filters and can you also suggest a worksheet function to
do this e.g. using the match funtion?

Thanks!

David