filtering out unwanted data

[John M.]

I am working in a worksheet with 15k rows of data. I have sorted and added subtotals. Is there a way to remove data based on number of occurrences? Example, if the same account number is listed less than times in the worksheet, i would like to eliminate the account number from the data. How can i achieve this?

[John M.]

I would like to remove the data row MCDO1230 (many similar rows of data) without scrubing throgh thousands of rows of data...


MCDO1228 0006 06/18/2014 12.01.39
MCDO1228 0007 06/13/2014 15.03.09
MCDO1228 0016 06/09/2014 00.51.24
3
MCDO1230 0001 07/08/2014 14.38.23
1