Forum Discussion

DownUnderling51's avatar
DownUnderling51
Copper Contributor
Dec 21, 2018

Cumulative count formula

Is there a way to count the number of occurrences of particular randomly generated values as they are generated?   Specifically:            Numbers from 1 to 10 are randomly generated in a particu...
excel
Formulas and Functions
Haytham Amairah's avatar
Haytham Amairah
Silver Contributor
Dec 22, 2018

Hi,

 

You definitely need to a VBA code to do so!

 

So I would suggest this one below and you will find it in the attached file.

Sub CountTheNumberOfRandomlyGeneratedValueCumulatively()
    Dim cell As Range

    For Each cell In Range("C1:C10")
        If cell.Value = Range("A1").Value Then
                cell.Offset(0, 1).Value = cell.Offset(0, 1).Value + 1
                Exit For
        End If
    Next
End Sub

 

Hope that helps

Resources