JMP equivalent of Excel's COUNTIF function
I'm trying to mimic this Excel-type behavior: AB1failureTypenumFailuresThisType2f1=countif($a$2:$a$999,a2)3f2=countif($a$2:$a$999,a3)4f1=countif($a$2...
BHarrisFind courses, tutorials, and lots of other methods of learning JMP.
view all learning resourcesI'm trying to mimic this Excel-type behavior: AB1failureTypenumFailuresThisType2f1=countif($a$2:$a$999,a2)3f2=countif($a$2:$a$999,a3)4f1=countif($a$2...
BHarrisI am trying to find a JMP formula function equivalent to Excel’s Countif function, that points to a column and returns the number of rows that are the...
DispersionSparkHi JMP friends,(On regular JMP 18.0.1, example data attached) I am analyzing some data wherein I need to find the time (x point) at which my data has...
RZordichHi All, I'm using JMP 18 and have a JMP file that uses a custom SQL query to create a data table. There are several dashboards (composed of graphs cre...
andykncI know this has been asked before, but I followed that solution and I cannot make it work. I am trying to import multiple files using MFI (which I can...
patriciafm811Hi JMP friends,(On regular JMP 18.0.1, example data attached) I am analyzing some data wherein I need to find the time (x point) at which my data has...
RZordichI know this has been asked before, but I followed that solution and I cannot make it work. I am trying to import multiple files using MFI (which I can...
patriciafm811I used "File"-->Database-->Open table-->New connection to setup some tables from DB. but I found my list for new connections becomes longer and longer...
Sean_ShCn0Hello JMP-Community,I am searching your help here because I didn't found a sufficent solution for myself in other posts. It is about writing content o...
DBo_94I had evaluate the JMP output for Brown-Forsythe and Levene's test for Equal Variance under Fit X-Y analysis module. The values from the JMP Fit X-Y ...
Brice_LI used "File"-->Database-->Open table-->New connection to setup some tables from DB. but I found my list for new connections becomes longer and longer...
Sean_ShCn0Hello JMP-Community,I am searching your help here because I didn't found a sufficent solution for myself in other posts. It is about writing content o...
DBo_94Hey,I just noticed that with the "newer" PI importer it's possible to pass a list with AF paths instead of just one AF path. But here's the problem: ...
Erik_The_FirstTypical dataset: 120-200 rows, 15 classes. Rows are known to be ordered by class. What is unknown is where the 'fences' between classes are. As-is -- ...
mtowle419Hi there,
I am attempting to run latin hyper cube with three continuous and one categorical factors, but the option is not available except for fast f...
New JMP users will learn how to: Easily navigate JMP using the JMP Starter. Import all types o...
Do you have historical or real time production data? Have you wondered how to leverage these data to...
New JMP users will learn how to: Easily navigate JMP using the JMP Starter. Import all types o...
Are you a manufacturing engineer who supports day-to-day operations? Do you need to launch an...