Excel 2007 - Select 10 or less employees for each company 1

[BxWill]

Have a 50,000+ record Excel worksheet with three columns;

Company---------Employee-------PhoneNbr
ABC-------------Jane Smith-----402 215-4000
ABC-------------Shirley Becker-402 123-4500
.
.
.
ABD-------------Bob Whall------402 145-2222
ABD-------------Carol Wills----302 223-2245

I need to identify 10 or less employees for each company.

Is there a method, IF formula, array formula, etc. that will enable this?

 

[SkipVought]

Use a PivotTable -- hard to find in Excel 2007 -- alt+D P

This brings up the PivotTable Wizard. Follow the bouncing ball and place the PT on your sheet with the fields you need.

Then in the PT, on the Employee Pivot Field -- Right-Click -- Select Field Settings > Advanced BUTTON -- Select Select your Sort or Top 10 options


Skip,

_{Just traded in my old subtlety...
for a NUANCE!}