View Single Post
  #1  
Old August 26th, 2008, 09:49 PM posted to microsoft.public.excel.worksheet.functions
freeman
external usenet poster
 
Posts: 8
Default need help with a formula

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.