Our World Statistics Day conversations have been a great reminder of how much statistics can inform our lives. Do you have an example of how statistics has made a difference in your life? Share your story with the Community!
Choose Language Hide Translation Bar
0 Kudos

Import Excel Formulas

I'd love to be able to import an excel spreadsheet into JMP, including formulas.  For example, each row in Excel Column C contains the sum of the cells from the same row in Columns A & B.  Could JMP be made to recognize that this means to create a table with 3 columns, where the 3rd column contains a formula adding the first 2 columns?


Of course there would be limitations (how to handle Excel rows that are the sums of other rows? how to handle Excel columns that are functions of single cells? Etc.), but even if only my example above were possible, this would be a great help.


Tracking Number:

Defect ID: