Vba to count occurrence if it appears more than 3 times

Hello,

need urgent assistance please

in the attached workbook column B contains unique Identifies. I want to be able to run a code to count all identifiers that have been entered 3 times or more ie count all identifiers and how many times that particular identifier is in column B

I kinda need this urgently and would really appreciate any help!

the attached file is a test file as the original contains 2000 plus identifiers that will need to be counted .

Thanks



also posted here

http://www.ozgrid.com/forum/showthread.php?t=198370

solution found.see link