I'm sorry that you're frustrated in your attempts to use the Formula Editor in JMP.
The first thing to recognize is that JMP isn't a spreadsheet like Excel (neither is Excel a structured data table like JMP).
When you create a new column and give it a formula. The formula applies to the entire column and is evaluated for every row in the column.
![6281_JMPScreenSnapz007.png 6281_JMPScreenSnapz007.png](https://community.jmp.com/t5/image/serverpage/image-id/369i3A906B3F38BFE005/image-size/medium?v=v2&px=400)
If you want to reference a specific row in a column you can use the Subscript option from the Row functions.
![6283_JMPScreenSnapz009.png 6283_JMPScreenSnapz009.png](https://community.jmp.com/t5/image/serverpage/image-id/370iA9DD522ED14375D9/image-size/medium?v=v2&px=400)
This will give you a subscript for the column you've got selected in the formula. You can put a row number in the subscript and you'll get the value for that column in the row specified.
This formula returns the value for ABRASION in row 3 for every row of this new column.
![6284_JMPScreenSnapz010.png 6284_JMPScreenSnapz010.png](https://community.jmp.com/t5/image/serverpage/image-id/371iB8AB1D858E4A337F/image-size/medium?v=v2&px=400)
Can you tell us what you're trying to do and how you've tried to do it and we can give you some pointers to accomplish it?
-Jeff
-Jeff