If Sheet1 holds the data and C1 on the new sheet contains
the sector, then place this in A1 of the new sheet, press
ctrl/shift/enter, and fill down:

=INDEX(Sheet1!$A$1:$A$12,SMALL(IF(Sheet1!
$B$1:$B$12=$C$1,ROW(Sheet1!$A$1:$A$12)),ROW()))

Put this in B1 and fill down:

=VLOOKUP(A1,Sheet1!A:C,3,0)

HTH
Jason
Atlanta, GA

-----Original Message-----
In column A, I have a list of names (Abbott, Addas,
Amling, Benner...)
In column B, I have the sector they are in (Media,
HealthCare, Media,
Telecom...)
In column C, I have their sales (24.5, 26.4, 30.0,
12.1...)

On another sheet, when I select a sector (say Media, in
cell D1), I want to
be able to recalculate and show Name (Col A) and Sales
(Col B), just for the
Media bankers

Is this possible? Also, Media might have 8 bankers, but
Technology might
have 4 bankers, so the formula would need to be able to
handle that variance
too.

Thanks in advance for any help

Daniel Bonallack
.