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

Limit occurrences using VBA 10
formula to count occurrences using multiple columns 2
How to count the numbers in a Word document? 0
Need formulas for searching for a value in a table and returning row/column name 7
Copy cells to different sheet if value found 1
Select minimum with duplicate values to return column headings 3
complex sort search and replace macro 2
Count Number of Unique Cells That Don't Have Certain Characters 0

Top