Compare many columns with possible empty values

Question

All,

Any ideas how to quickly do the following task:

I have N columns with values, that ideally should be identical, or some values might be missing (this is OK). I need to see if for a specific row either all the values are the same or missing, or if there is at least one column with value that is not the same?

txnelson · Answer

I suggest you look at the Missing Values Analysis available in JMP.
     Tables==>Missing Data Pattern

miguello · Answer

Ok, I got it.

Provided the values are numerical, you can just calculate range between columns, doing this:

Maximum(
) - Minimum(
)

If it's not zero - there is difference in at least one column.