Find Excel Duplicates

[marsjanik1]

Hi
I have a very large spreadsheet. I need to extract only the records that are duplicated 4 times. I know how to find duplicates but not with the criteria where there must be 4 matches. I know that i can sort the spreadsheet but it is very long and i only need to see those records that are duplicated 4 times. Any helpwould be appreciated.

Thanks,

[oeldere]

Maybe like this:

=if(countif($a$1:$a1,a1)=4,4,"")