Extracting 2 values in a list in one condition, and 1 in another condition

[rizzo93]

I have a list of names on one Worksheet B that I want to display two at a time on Worksheet A...but with a twist.

Each name belongs to a group, and because the number of names isn't always even, they can't always be shown in pairs. So I need help finding a way to only show the last name in the group and NOT display the name in the other group when that condition applies.


Worksheet B:

	A	B
1	Clark	Marketing
2	Lois	Marketing
3	Frank	Marketing
4	Joey	Accounting
5	Sarah	Accounting

<tbody>
</tbody>

So on Worksheet A I want to show...


Clark
Lois


...as the first pair. When I click my spin button, I then want to show just Frank because he's the last person in Marketing but NOT Joey because he's in Accounting.


Click the spin button again and I want to show Joey and Sarah, both from Accounting. And so the variation continues with names and departments.


Here are the details:


Spin counter cell: P3


N6 is first name
=INDIRECT("E" & 1+($P$3*2))


N7 is second name
=INDIRECT("E" & 2+($P$3*2))

Your help is much appreciated!