Which is? There were two options there.

--
__________________________________
HTH

Bob

"freeman" wrote in message
...
That is correct.

"Bob Phillips" wrote:

Do you mean those items repeated twice as against those repeated 5 times?
And then those repeated 2 or 3 time as against 5 times?

--
__________________________________
HTH

Bob

"freeman" wrote in message
...
Bob,

This Array worked great, Thank you. Is is possible to modify this to
display
something that repeated twice. As well as something that repeated 2-3
and
2-4
times?

Regards

Michael

"Bob Phillips" wrote:

Change B2 to

=IF(COUNTIF($A$2:$A2,A2)1,"",COUNTIF($A$2:$A$7610 ,A2))

and copy down.

Then in some spare column, row 1, add

=IF(ISERROR(SMALL(IF(($B$2:$B$7610<"")*($B$2:$B$7 610=5),ROW($A$2:$A$7610)-MIN(ROW($A$2:$A$7610))+1,""),ROW($A1))),"",
INDEX(A$2:A$7610,SMALL(IF(($B$2:$B$7610<"")*($B$2 :$B$7610=5),ROW($A$2:$A$7610)-MIN(ROW($A$2:$A$7610))+1,""),ROW($A1))))

which is an array formula, so commit wit Ctrl-Shift-Enter, and copy
down
as
far as you might need, and acroos one column.

--
__________________________________
HTH

Bob

"freeman" wrote in message
...
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.