Finding duplicates, and keeping them with totals

[mcguitar]

Long time lurker, first time poster...

I have a database with ~18000 rows and 29 columns. I would like to filter the data by duplicates in one column, based on total, but keep the remaining data in the row. For example:
I have account numbers listed in one column, often duplicates. I can get the total in a pivot table no problem, but need the other data associated with that account. I do not need to see all accounts, only duplicates for accounts listed say greater than 5 times. The data in columns B+ are important.

Is there an easy way to do this? I have a HUGE vlookup I created to paste in the pivot table data (account numbers and totals) to run a look-up based on those numbers, but I see that running into problems when you run 4k+ look-ups.

To help clarify, I want to see accounts listed only 5+ times, include that total (as in a pivot table) and the remaining 28 columns. I have tried to run this in a pivot table completely, but still too much data to process (plus all the subtotals that I have to keep removing).

Thank you all in advance!

 

[JoeMo]

Consider adding a helper column with a formula like this (assuming account duplicates are in column B and data start in row 2):
=IF(COUNTIF(B:B,B2)>5,"X","")
copy down to cover all the data, then filter on "X" in the helper column.