Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel Filtering doesn't work with large files | Excel Discussion (Misc queries) | |||
Filtering a protected WS in a shared workbook - Excel 2000 | Excel Discussion (Misc queries) | |||
avanced filtering for latest date | Excel Discussion (Misc queries) | |||
Filtering | Excel Discussion (Misc queries) | |||
Using Filtering | Excel Discussion (Misc queries) |