Filtering to show only multiple instances...

**Amanda&Dan** · 03-13-2008, 07:22 AM

Hi,
this is probably really simple to do, but I'm kind of a self taught excel user and don't really know how to use it that well, sorry!
I've just started in a new position at work, and part of my job is to update a certain file which keeps a record, month by month, as well as a big overall file, to show feedback received by employees, both positive and negative. Every month a new tab is added to the spreadsheet to list names, type of feedback (positive/negative) and what criteria that feedback falls in to. The information from the monthly tab is then just added to the bottom of the master sheet.
I figure it's going to be easier to see which employees are excelling, or not, by being able to filter by the name column on the master sheet, to show only names which occur more than once (or more than 3 or 4 or whatever they decide the threshold will be).

Can anyone tell me how to do this? I think it's office 2003 at work.

Any help, or to tell me if this is possible or not, or even if anyone has an easier way to do it, would be very much appreciated!

Thanks,
Amanda

**NBVC** · 03-13-2008, 08:09 AM

You would need to add a helper column with a formula in it... then filter that column...

e.g. =Countif(A:A,A1) copied down gives you the number of occurances of each of the items in column A starting at A1.

Now you can filter by any of the numbers or even custom filter for greater than or equal to, etc....