I want to hide and exclude specific rows that I have marked with a certain symbol or color. These rows are scattered throughout my data set and I don't want to manually hide and exclude all of them. I also want to be able to reverse the hide and exclude function for the specific cells in order to compare my original and edited data. Does anyone have tips on what I should do?
One possible solution is to create a new numerical - Nominal column with the formula: "Color of ()" and then using it to select the rows that match your annotations. It's certainly not perfect but it should do the trick rapidly.
The only way that I know of to get that information, is to write a script that interrogates the script for the column of interest. If you use << get script to retrieve the script for a given column, it will provide you something you can scan through to get the color information
Using the Big Class sample JMP table in which I colored a few of the cells for the Height column and requesting