You could use this formula in C1 of Tab1:
and copy this down as far as you need to. It will give you something
and so on, i.e. you have a sequential count of Bob's tasks, and of
Tim's tasks, and this gives you a unique reference. In your other
sheet you can then make use of an INDEX/MATCH combination, also using
the ROW() function arranged however you wish.
Hope this helps.
> Bob Recon>ile Cash
> Tim Do>Sales Report
> Bob r>ate presentation
> Tim Prepare>financial statements
> Bob > gt;Hire staff person
> Now on tab two, I want to create another list>that pulls all the tasks
> together by person. For example, Ta> 2 would look like this:
>> Bob econcile Cash
>>Bob reate presentati>n
> Bob ire staff>person
> Tim o Sales Report
>>Ti> repare financial statement.
> I realize I can just sort this lis> by name but I don't want Tab 2 to work
> like that. I'm frequently shuffling>tasks between people so I want Tab 2 to
> automatically update as I'm movin> tasks around between people. I want to
> have some form of lookup formula in>Tab 2 that says "get the first task for
> Bob and return it," and then "get the second task for Bob and return it."