Reporting on Top and Bottom Sales Figures

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

BRob - 12 May 2008 08:59 GMT

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

Reply to this Message

Pete_UK - 12 May 2008 09:06 GMT

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.
>
[quoted text clipped - 10 lines]
>
> TIA

Reply to this Message

BRob - 12 May 2008 17:50 GMT

Tx for the suggestion.

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

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.
>
[quoted text clipped - 11 lines]
>
> TIA

Reply to this Message

Rate this thread: