Reporting on Top and Bottom Sales Figures

[BRob]

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]

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

 

[BRob]

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