How To find identical values

[marcgijsman]

Hi
I have a sheet with in which i like to find identical values and report
in how many times does this value appear.
A B C D
x y z x =3
r x r y =1
f f z z =2
r =1
f =2
I have tried several functions but no luck, can anyone tell me how to
do this?

Thanks in advance

 

[Bondi]

Hi
I have a sheet with in which i like to find identical values and report
in how many times does this value appear.
A B C D
x y z x =3
r x r y =1
f f z z =2
r =1
f =2
I have tried several functions but no luck, can anyone tell me how to
do this?

Thanks in advance

Hi,
Maybe you can use something like:

=COUNTIF(A1:C3,"f")

Regards,
Bondi