Try this in B2:

=IF(COUNTIF($A$2:$A$7610,A2)5,A2&" - "&COUNTIF($A$2:$A
$7610,A2),COUNTIF($A$2:$A$7610,A2))

Then copy it down. I've assumed yo still want the count in column B
for those items which do not appear more than 5 times. If you don't
want this, then simplify the formula to:

=IF(COUNTIF($A$2:$A$7610,A2)5,A2&" - "&COUNTIF($A$2:$A$7610,A2),"")

Hope this helps.

Pete

On Aug 26, 9:49*pm, freeman wrote:
I have an excel file that looks like this.
Column A has a long list of names, many that repeat
Column B has a the following formula =COUNTIF($A$2:$A$7610,A2) that will
look at column A and tell me how many times an item is repeating.

What I am looking for is the ability to take both column A and B and display
the following information.

Items that repeated more then five times will show the relevant data from
column A and B in this column.

Any Ideas?

BTW I am not very good at VB.