cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
JMP is taking Discovery online, April 16 and 18. Register today and join us for interactive sessions featuring popular presentation topics, networking, and discussions with the experts.
Choose Language Hide Translation Bar
LarsBirger
Level II

Is there a way to identify in a simple way if a cell is empty?

Is there a way to identify in a simple way if a cell is empty?

I have the following question:

 

In my JMP file there are two methods described. If method 1 is used there will be some text in that column. If method 2 is used the cell under method 1 will be empty and there will be som text under method 2. I know how to like in Excel filter data but I wonder if there is a formula that one can use to identify empty cells like in the example below.

 

Method 1      Method 2       Which method used

klkjkjj                                    Method 1

kjlljuun                                  Method 1

                     uoiuonj            Method 2

lkjljlk                                     Method 1

                     lkjljlkiiuuoi       Method 2

 

Would very much appreciate if someone has a solution to how I could write a formula in the column Which method used.

 

Sincerely yours

 

Lars Enochsson

 

2 ACCEPTED SOLUTIONS

Accepted Solutions
uday_guntupalli
Level VIII

Re: Is there a way to identify in a simple way if a cell is empty?

txnelson
Super User

Re: Is there a way to identify in a simple way if a cell is empty?

The function to use is

     isMissing()

It can be used for both numeric and character columns.  So if you used the following to detect if the 2nd row of the column Method 2 is empty(missing)

     isMissing(:Method 2[2])

It would return a value of 1.  That is, the cell is empty.

Jim

View solution in original post

2 REPLIES 2
uday_guntupalli
Level VIII

Re: Is there a way to identify in a simple way if a cell is empty?

@LarsBirger,
  IsMissing()

Best
Uday
txnelson
Super User

Re: Is there a way to identify in a simple way if a cell is empty?

The function to use is

     isMissing()

It can be used for both numeric and character columns.  So if you used the following to detect if the 2nd row of the column Method 2 is empty(missing)

     isMissing(:Method 2[2])

It would return a value of 1.  That is, the cell is empty.

Jim