RobFJ wrote:
I've got a spreadsheet of pay information for about eight hundred
people. Each person is on one of eight salary scales

I'd like to create a new worksheet that shows the details of just the 5
highest paid people in each scale (name, dept, salary, etc.) - and also
the five lowest. Ideally, I'd like also to be able to vary that number -
eg the top ten, the highest, etc..

Can someone help?

Thanks







Try a PivotTable. If you aren't familiar with them, look he

http://peltiertech.com/Excel/Pivots/pivotstart.htm