topic Re: How can I count no of repetitive entry in a different column using formula. in Discussions https://community.jmp.com/t5/Discussions/How-can-I-count-no-of-repetitive-entry-in-a-different-column/m-p/724739#M90791 <P>Thank you</P> Mon, 19 Feb 2024 21:43:58 GMT ConfidenceOwl94 2024-02-19T21:43:58Z How can I count no of repetitive entry in a different column using formula. https://community.jmp.com/t5/Discussions/How-can-I-count-no-of-repetitive-entry-in-a-different-column/m-p/724724#M90784 <P>I need to count no of test that were performed on particular SN. see atteched example.&nbsp;</P> Mon, 19 Feb 2024 20:21:14 GMT https://community.jmp.com/t5/Discussions/How-can-I-count-no-of-repetitive-entry-in-a-different-column/m-p/724724#M90784 ConfidenceOwl94 2024-02-19T20:21:14Z Re: How can I count no of repetitive entry in a different column using formula. https://community.jmp.com/t5/Discussions/How-can-I-count-no-of-repetitive-entry-in-a-different-column/m-p/724729#M90785 <P>You can use Col Cumulative Sum for this type of calculation in a formula</P> <PRE><CODE class=" language-jsl">Col Cumulative Sum(1, :SN)</CODE></PRE> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="jthi_0-1708375701259.png" style="width: 400px;"><img src="https://community.jmp.com/t5/image/serverpage/image-id/61257iFE61BEE52031ABD6/image-size/medium?v=v2&amp;px=400" role="button" title="jthi_0-1708375701259.png" alt="jthi_0-1708375701259.png" /></span></P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="jthi_1-1708375704940.png" style="width: 400px;"><img src="https://community.jmp.com/t5/image/serverpage/image-id/61258i57A0DD1F121F72E1/image-size/medium?v=v2&amp;px=400" role="button" title="jthi_1-1708375704940.png" alt="jthi_1-1708375704940.png" /></span></P> <P>&nbsp;</P> Mon, 19 Feb 2024 20:48:34 GMT https://community.jmp.com/t5/Discussions/How-can-I-count-no-of-repetitive-entry-in-a-different-column/m-p/724729#M90785 jthi 2024-02-19T20:48:34Z Re: How can I count no of repetitive entry in a different column using formula. https://community.jmp.com/t5/Discussions/How-can-I-count-no-of-repetitive-entry-in-a-different-column/m-p/724739#M90791 <P>Thank you</P> Mon, 19 Feb 2024 21:43:58 GMT https://community.jmp.com/t5/Discussions/How-can-I-count-no-of-repetitive-entry-in-a-different-column/m-p/724739#M90791 ConfidenceOwl94 2024-02-19T21:43:58Z