C
Cinny
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
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