https://community.jmp.com/t5/Discussions/How-to-specify-a-data-cell-into-a-column-formula/m-p/724747#M90794 <P>Thank you!</P> Mon, 19 Feb 2024 22:27:41 GMT Mcc99 2024-02-19T22:27:41Z https://community.jmp.com/t5/Discussions/How-to-specify-a-data-cell-into-a-column-formula/m-p/724741#M90792 <P>I am having trouble writing a simple column formula as I do not know the syntax to specify a specific datapoint/cell within the formula itself. In the past, I have manually entered the value, but am trying to streamline the process using action recorder/scripts.</P><P>I need to subtract column #1row #5 from every value in column #1 and put the resulting value into column#2. For example, i<SPAN>n Excel, the formula would be =A1-$A$5. But I don't know how to specify a specific column/row in JMP formulas.&nbsp;</SPAN>I'm using JMP Pro 16 on windows.&nbsp;</P> Mon, 19 Feb 2024 22:03:15 GMT https://community.jmp.com/t5/Discussions/How-to-specify-a-data-cell-into-a-column-formula/m-p/724741#M90792 Mcc99 2024-02-19T22:03:15Z https://community.jmp.com/t5/Discussions/How-to-specify-a-data-cell-into-a-column-formula/m-p/724745#M90793 <P>You use <A href="https://www.jmp.com/support/help/en/17.2/index.shtml#page/jmp/row-functions.shtml" target="_self">subscripts</A> to reference a specific row.</P> <P>&nbsp;</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="2024-02-19_17-20-52.748.png" style="width: 400px;"><img src="https://community.jmp.com/t5/image/serverpage/image-id/61260i8FDD4B9E236E90FB/image-size/medium?v=v2&amp;px=400" role="button" title="2024-02-19_17-20-52.748.png" alt="2024-02-19_17-20-52.748.png" /></span></P> <P> </P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="2024-02-19_17-21-05.956.png" style="width: 400px;"><img src="https://community.jmp.com/t5/image/serverpage/image-id/61261i704C74696D2645DE/image-size/medium?v=v2&amp;px=400" role="button" title="2024-02-19_17-21-05.956.png" alt="2024-02-19_17-21-05.956.png" /></span></P> <P>&nbsp;</P> Mon, 19 Feb 2024 22:21:49 GMT https://community.jmp.com/t5/Discussions/How-to-specify-a-data-cell-into-a-column-formula/m-p/724745#M90793 Jeff_Perkinson 2024-02-19T22:21:49Z https://community.jmp.com/t5/Discussions/How-to-specify-a-data-cell-into-a-column-formula/m-p/724747#M90794 <P>Thank you!</P> Mon, 19 Feb 2024 22:27:41 GMT https://community.jmp.com/t5/Discussions/How-to-specify-a-data-cell-into-a-column-formula/m-p/724747#M90794 Mcc99 2024-02-19T22:27:41Z