count simlilar values

[legolas]

dear all,

I got in A about 900 different names which are repeated randomly. i am trying to create a summary to show
each name how many times it appeared , is there an easy way instead of counting each name in a cell

thanks for any help

[Fotis1991]

Hi

...is there an easy way instead of counting each name in a cell

What you mean?

[legolas]

Hi



What you mean?

a formula maybe to count how many times a name appeared !! not manually ...you know !

[vlady]

maybe like this
A1 = "Smith" the name to search and count

=IFERROR(SUMPRODUCT(LEN(A2:E900)-LEN(SUBSTITUTE(UPPER(A2:E900),UPPER(A1),"")))/LEN(A1),"")

[Fotis1991]

So. not manually, you mean this.

=COUNTIF(A:A,"Fotis")

OR
=COUNTIF(A:A;a1)

[legolas]

i attached sample file since non of formulas worked so far

so i just need in "H" the name and in "I" number of times it was repeated.

thanks for your help

[zbor]

So why Fotis solution doesn't work for you??

=COUNTIF($E$3:$E$1000,$H3)

[Kevin UK]

Hi legolas

COUNTIF function entered into I3:I19

test1.xlsx

[legolas]

Hi legolas

COUNTIF funcyion entered into I3:I19

Attachment 163309

works , thank you

[Fotis1991]

@ Zbor

So your formula, does not work!

[zbor]

Probably because I didn't unmerged users cells

[nazmul_muneer]

You can use COUNTIF() function, SUMPRODUCT() function or PIVOT TABLE for solving this porblem