Frequency of outcome

[thong]

Hello All,

I have 4 columns with different numbers from 1-35. I want to know the frequency how many times they are use from each columns.

Please find attached file.

Thank you.

 

[Khalid NGO]

Hi thong,

Can you include your expected results?

Just a guess, a simple countif can be used in G2:
=COUNTIF(A$2:A$10,$F2)

Copy down and across...

Regards,

 

[thong]

Hi Khalid,

My expected result is in G2, it will tell me how many times for example number 1 appeared on each column.

 

[Khalid NGO]

Can you include your expected results?

Hi Thong,

I mean can you include your expected results manually? so that we can cross check.

As i guessed for result in separate columns, you can use above formula.

For result in single column, try this in G2 and copy down:
=SUMPRODUCT(($A$2:$D$10=F2)+0)

This should work or I've completely misunderstood your question?

Regards,

 

[thong]

Hi Khalid,

The result that I want is the output of your formula.

Big Thanks...

 

[Khalid NGO]

Great...
Glad it helped.

Thanks for the feedback.
Take Care

 

[John Jairo V]

Hi, to all!

And... why not:
=COUNTIF(A$2:D$10,F2)

Blessings!