Home |
Search |
Today's Posts |
#1
|
|||
|
|||
how to find all matches in an array
I have a task list that in one column lists the person primarily responsible
for it and in the 2nd column is the back up person. The 3rd column is the task. On another sheet I want to put in someones name and bring up all tasks they are responsible for and all the tasks they are backup for. What is an easy way to do this. |
#2
|
|||
|
|||
Easiest way IMHO would be to use advanced filter
http://www.contextures.com/xladvfilter01.html -- Regards, Peo Sjoblom (No private emails please) "Greg" wrote in message ... I have a task list that in one column lists the person primarily responsible for it and in the 2nd column is the back up person. The 3rd column is the task. On another sheet I want to put in someones name and bring up all tasks they are responsible for and all the tasks they are backup for. What is an easy way to do this. |
#3
|
|||
|
|||
"Peo Sjoblom" wrote: Easiest way IMHO would be to use advanced filter http://www.contextures.com/xladvfilter01.html -- Regards, Peo Sjoblom (No private emails please) "Greg" wrote in message ... I have a task list that in one column lists the person primarily responsible for it and in the 2nd column is the back up person. The 3rd column is the task. On another sheet I want to put in someones name and bring up all tasks they are responsible for and all the tasks they are backup for. What is an easy way to do this. Thanks for the suggestion - I will try it that way |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how to find duplicate cells in large array of numbers | Excel Worksheet Functions | |||
Find within Workbook. | Excel Discussion (Misc queries) | |||
find maximum of two values in an array with same lookup value | Excel Discussion (Misc queries) | |||
How do I find a value in an array (VLOOKUP? HLOOKUP?) | New Users to Excel | |||
Use of the DSUM formula to find exact matches in datatables | Excel Worksheet Functions |