cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
‘New to using JMP? Hit the ground running with the Early User Edition of Discovery Summit – register now, free of charge.
Register for our Discovery Summit 2024 conference, Oct. 21-24, where you’ll learn, connect, and be inspired.
Choose Language Hide Translation Bar

How can I count no of repetitive entry in a different column using formula.

I need to count no of test that were performed on particular SN. see atteched example. 

1 ACCEPTED SOLUTION

Accepted Solutions
jthi
Super User

Re: How can I count no of repetitive entry in a different column using formula.

You can use Col Cumulative Sum for this type of calculation in a formula

Col Cumulative Sum(1, :SN)

jthi_0-1708375701259.png

jthi_1-1708375704940.png

 

-Jarmo

View solution in original post

2 REPLIES 2
jthi
Super User

Re: How can I count no of repetitive entry in a different column using formula.

You can use Col Cumulative Sum for this type of calculation in a formula

Col Cumulative Sum(1, :SN)

jthi_0-1708375701259.png

jthi_1-1708375704940.png

 

-Jarmo

Re: How can I count no of repetitive entry in a different column using formula.

Thank you