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...
This US session is held in English, 1:00 pm US Eastern Time. New JMP users will&n...
This webinar is in English, 2:00 p.m. US Eastern Time. See how to use JMP to understand and i...
This 45-minute webinar is given in English at 1PM (Singapore, Malaysia), 10:30AM (India),...
This US session is held in English, 1:00 pm US Eastern Time. New JMP users will&n...