Compare many columns with possible empty valuesAll,
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?
Re: Compare many columns with possible empty valuesOk, 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.
Re: Compare many columns with possible empty valuesI suggest you look at the Missing Values Analysis available in JMP.
Tables==>Missing Data Pattern
