Return repeating values?

  • Thread starter Thread starter A Nony Mouse
  • Start date Start date
A

A Nony Mouse

Hi all...

I work at a graduate school college and would like to write a forumla in an
excel spreadsheet that will return the values in a column that repeat more
than three times...

For example, we want to publish the undergraduate schools attended by more
than 3 of our students... So, in the column containing undergrad school, I
want to return those schools that occur > 3 times.

That's the first question... And I covet your help.

Thanks so much! Brian
 
Hi
one way. insert the following formula in a helper column
=COUNTIF($A$1:$A1,A1)
and copy down

Now filter all rows with a value >=3
 
Back
Top