Excel - Find the number of occurrences of a number

Ask a question

Issue


I want to know how many times a number repeats itself in the list below:
1 4  
2  
3  
4  
7 6  
8  
9  
10  
11  
12  
15 single 
17 3  
18  
19 

Solution


Try this formula :

=IF(A2=A3-1,"",IF(AND(A2<>A3-1,A2<>A1+1),"single",COUNTIF($A$1:A1,"<>")-SUM($B$1:B1)-COUNTIF($B$1:B1,"single"))) 

Thanks to Vaucluse for this tip.
Jean-François Pillou

CCM is a leading international tech website. Our content is written in collaboration with IT experts, under the direction of Jeff Pillou, founder of CCM.net. CCM reaches more than 50 million unique visitors per month and is available in 11 languages.

Learn more about the CCM team