Reporting on Top and Bottom Sales Figures

I've got a table with columns of Sales Reps names and their Total Sales.

I want to create a new worksheet that has two tables - one of the names of
the Reps with the highest sales figures and one with the lowest. I want to
be able to vary those figures - so will need to keep them as constants -
with range names, say, 'High' and 'Low'.

If possible I want the table of the highes figures above the one with the
lowest - so I can print off onto one piece of paper.

How do I do it, bearing in mind the number of rows will change depending on
the values I put if for 'High' and 'Low'

TIA

Pete_UK
Mon May 12 03:06:55 CDT 2008

Rather than have a variable number of rows for different values of
High and Low, it might be better to show the Top-10 highest and the
Top-10 lowest.

Hope this helps.

Pete

On May 12, 8:59=A0am, "BRob" <del**eteto-hash#rfj1...@ntlworld.com>
wrote:
> I've got a table with columns of Sales Reps names and their Total Sales.
>
> I want to create a new worksheet that has two tables - one of the names of=

> the Reps with the highest sales figures and one with the lowest. I want to=

> be able to vary those figures - so will need to keep them as constants -
> with range names, say, 'High' and 'Low'.
>
> If possible I want the table of the highes figures above the one with the
> lowest - so I can print off onto one piece of paper.
>
> How do I do it, bearing in mind the number of rows will change depending o=
n
> the values I put if for 'High' and 'Low'
>
> TIA

BRob
Mon May 12 11:50:51 CDT 2008

Tx for the suggestion.

However, I do need to flex the value that I look up - rather than the number
of records to report.



"Pete_UK" <pashurst@auditel.net> wrote in message
news:12644c40-5837-492e-a2ac-2621a17b7294@l42g2000hsc.googlegroups.com...
Rather than have a variable number of rows for different values of
High and Low, it might be better to show the Top-10 highest and the
Top-10 lowest.

Hope this helps.

Pete

On May 12, 8:59 am, "BRob" <del**eteto-hash#rfj1...@ntlworld.com>
wrote:
> I've got a table with columns of Sales Reps names and their Total Sales.
>
> I want to create a new worksheet that has two tables - one of the names of
> the Reps with the highest sales figures and one with the lowest. I want to
> be able to vary those figures - so will need to keep them as constants -
> with range names, say, 'High' and 'Low'.
>
> If possible I want the table of the highes figures above the one with the
> lowest - so I can print off onto one piece of paper.
>
> How do I do it, bearing in mind the number of rows will change depending
> on
> the values I put if for 'High' and 'Low'
>
> TIA