View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Cinny Cinny is offline
external usenet poster
 
Posts: 19
Default Customer name when in TOP 5 growth

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