Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.

- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page

Highlighted

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Email to a Friend
- Report Inappropriate Content

Aug 16, 2018 7:38 AM
(5049 views)

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.

**Metho****d 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

Highlighted

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Email to a Friend
- Report Inappropriate Content

Highlighted

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Email to a Friend
- Report Inappropriate Content

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

2 REPLIES 2

Highlighted

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Email to a Friend
- Report Inappropriate Content

Highlighted

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Email to a Friend
- Report Inappropriate Content

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

Article Labels

There are no labels assigned to this post.