Well, you would normally use an INDEX/MATCH combination to return the
name from your list where there is a corresponding match with the
growth value that you have identified with your LARGE and SMALL
functions.

The main problem with this is that MATCH will only find the first
match where you might have 2 or more names with the same growth
figure, so you have to devise a way of picking up those duplicates.

I can't give you specific formulae as you give no details of how your
data is laid out (and it's getting late here), but if you provide
further details I'm sure someone will pitch in while I'm having a
sleep.

Hope this helps.

Pete

On Nov 5, 12:50*am, Cinny wrote:
Hi

I am trying to generate a summary report of the top 5 and bottom 5 growth
customers for each product range. *The growth data and customer names are in
one sheet and the summary is another. I understand how to bring back the top
and bottom 5 numeric figures in each product typer by using the large and
small formula's however I also need to bring back the customer name that
relates to that figure. *

Any help would be great. *Oh! and I can't use pivot tables if at all possible.

Cin