cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Try the Materials Informatics Toolkit, which is designed to easily handle SMILES data. This and other helpful add-ins are available in the JMP® Marketplace
Choose Language Hide Translation Bar
ConfidenceOwl94
Level III

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
ConfidenceOwl94
Level III

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

Thank you