Counting Values from a Single Column

[elmotactics]

I have an unfortunately formatted report of repeat callers. It's a single column, with the phone number, and then all the dates/times it called in the cells blow it, and then the next number, and all the dates/times it called, etc... for thousands of cells. What I need to do is somehow count all the times each number called. It would look something like this:

[TABLE="width: 500"]
<tbody>[TR]
[TD]Phone number 1[/TD]
[/TR]
[TR]
[TD]9/25/17 10:13am
[/TD]
[/TR]
[TR]
[TD]9/25/17 11:36am[/TD]
[/TR]
[TR]
[TD]Phone number 2[/TD]
[/TR]
[TR]
[TD]10/03/17 8:28am
[/TD]
[/TR]
</tbody>[/TABLE]
etc...

Is it possible to count the number of cells after each phone number until it runs up to the next phone number?

 

[elmotactics]

=IF(A1>100000,IFERROR(MATCH(TRUE,A2:$A$5000>100000,0)+ROW(A1)-1,COUNTA($A$1:$A$5000))-ROW(A1),"")

Confirm with CTRL-SHIFT-ENTER
Copy down.

Awesome, this worked! I had actually just arrived at the same conclusion (albeit much more roundabout) using 3 other formulas:

=IF(LEN(A2)=10,"Number","Date") To distinguish between dates and numbers

=MIN(IF(B2:B1280="Number",ROW(B2:B1280)-ROW(B2)+1))-1 As an array to count the number of dates after every number

=IF([@Count]=0,C3,"") To put the count in the same row as the number and leave blanks for everything else


Yours is much simpler though