Numbers
Hey everyone,
I have a little question
In the first collum A:A i have a serie of random numbers ,
Now i wanna know how manny times a specific number appears after another specific number?
for exp. Lets say the numbers go from 1 to 40
and this is the serie 1,5,12,30,35,5,12
The answer on how manny times 12 hit after 5 is now Two times.
Does ennyone could help me on the function/Formule?
Greets Harmle55
| Attachment | Size |
|---|---|
| Map-numbers.xlsx | 9.05 KB |
Assuming that a)
Assuming that
a) "AfterNumber" is the number which marks the start of the count
b) Randomdata is your series of random numbers
you use the match function to find the point in the data to start searching from
Startpoint=MATCH(AfterNumber,RandomData,0)
Once you've found your startpoint you use offset and countif to find the count
=COUNTIF(OFFSET(DataStart,StartPoint,0,100-StartPoint,1),F8)
simple
=AND(RC[-1]=5,R[1]C[-1]=12)
=COUNTIF(RC[-1]:R[9]C[-1],"true")