Spreadsheet Formula

[pistol17]

Hi Guys,

Just wondering if someone can help with a formula in excel. What I have is a list a names in a column, what I want to do is search this column to find 3 or more cells which are the same. Once this has been located I want it to display the name.

Any help would be appreciated, have been fiddling with this for a little while and doing my head in haha.

Thanks guys.

 

[CF]

is this what you want: Click here

 

[Munga]

You could try using the field filter, then copy "unique" fields to another column.
Then do a count next to those unique cells, or a countif to highlight those 3 or more.

 

[HarryTiger]

I have names from A3 to A20.

On the right of each cell starting at B3 paste

=IF(COUNTIF(A3:A20,A3)>=3,A3,"")

or =IF(COUNTIF($A$3A$20,A3)>=3,A3,"")

That shows the name in B if the count of that name in A is 3 or greater.

That counts below only but will show duplicates where the count is > 3. (always if second used)

To show once only nest the above formula in another COUNTIF which counts from first cell to the cell above for that name and only applies the first COUNTIF when the name is not repeated above.

 

[pistol17]

I have names from A3 to A20.

On the right of each cell starting at B3 paste

=IF(COUNTIF(A3:A20,A3)>=3,A3,"")

or =IF(COUNTIF($A$3A$20,A3)>=3,A3,"")

That shows the name in B if the count of that name in A is 3 or greater.

That counts below only but will show duplicates where the count is > 3. (always if second used)

To show once only nest the above formula in another COUNTIF which counts from first cell to the cell above for that name and only applies the first COUNTIF when the name is not repeated above.

Thanks mate, big help