How to count two cells occurrences in a worksheet

B

ben mustapha

Dear Expert,
I have a excel worksheet of 5 column and 100 rows with random cells values, I would like to count the occurrence of two cells in the worksheet. For example, if A1=1, A2=3 and C5=1 and C6=3 then the occurrence number is 2, and so on...

Thanks
 
B

Bernard Liengme

Do you wish to count how many times two adjacent cells hold the same
numbers? Is this any pairs of numbers or 1 and 3 specifically? Does (1, 3)
match (3, 1) or is the order important?
 
S

Sheeloo

Need more information...

Do you want to count the occurences of each number in the worksheet?
=Countif(A1:E100,1) will give you the count of times 1 occurs in first five
columns and 100 rows...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Auto-Numbering Occurrences Question 4
Excel Copy cells from one worksheet to another workseet - increment row & do again 0
Most common occurrence of a string 1
Use Formula from another worksheet 3
How do I count # of cells with same value other column? 4
How do I index the LAST occurrence of a duplicate number in a colu 12
Count rows based on multiple criteria 3
complex sort search and replace macro 2

Top