You could use this formula in C1 of Tab1:

=A1&"_"&COUNTIF(A$1:A1,A1)

and copy this down as far as you need to. It will give you something
like this:

Bob_1
Tim_1
Bob_2
Tim_2
Bob_3

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.

Pete

On Dec 10, 8:58*pm, Scott wrote:
I have a spreadsheet that looks like the following. Tab 1. Col A=Name. Col B
= Task.

A * * * * * * * B
Bob * * * * Reconcile Cash
Tim * * * * Do Sales Report
Bob * * * * *Create presentation
Tim * * * * Prepare financial statements
Bob * * * * Hire staff person

Now on tab two, I want to create another list that pulls all the tasks
together by person. For example, Tab 2 would look like this:
Bob * * * *Reconcile Cash
Bob * * * *Create presentation
Bob * * * *Hire staff person
Tim * * * *Do Sales Report
Tim * * * *Prepare financial statement.

I realize I can just sort this list 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 moving 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."