nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

405776_en-US

liliconcom

Excel formula plugin

MS Excel has a very intuitive and easy to use formula editor, where you can click on any cell in the table and give it a value of "=" + function. Thus, it is very easy to calculate for instance MEAN or STDEV of a selection of columns (i.e., A1:A10) or rows (i.e., A1:J1).

Would something like that be possible to implement in JMP? Or maybe it is already possible, but I don't know about.

Data Blending and Cleanup

Mass Customization

Re: Excel formula plugin

Thanks for some useful links, I read through them quickly and it kind of opened my eyes.

Re: Excel formula plugin

Hi @ruskicar ,

Have you seen how easily you can create a formula column by right-clicking on column headers?

You can also set a column to "Group By" so that you can get summary statistics for one column grouped by categories in another column.

I would also refer you JMP is Not a Spreadsheet. There are really good reasons for why JMP works on column-wise basis and not cell-wise. If you need spreadsheet functionality, spreadsheet software will be a better solution.