Using JMP • Enter and Edit Data • Select Cells
Previous
 • 
Next
Select Cells
To select a block of cells
•
Drag the arrow cursor diagonally across the cells.
JMP can find all cells whose values are the same as the ones you currently have highlighted. You can do this within one data table or throughout all open data tables. Highlight the cells that contain the values that you want to locate.
To find all matching cells within the active data table
•
Select Rows > Row Selection > Select Matching Cells
or
•
Right-click one of the highlighted row numbers and select Select Matching Cells.
To find all matching cells across all open data tables
•
Select Rows > Row Selection > Select All Matching Cells. The rows that contain the same values as the selected ones are highlighted.
To select cells that contain specific values
JMP can search for a specific value (or text string) and highlight all of the cells in the data table that contain the specific value.
1.
Select Rows > Row Selection > Select Where.
Specify Criteria for Selecting Rows
2.
From the column list, highlight the name of the column whose rows you want to select.
3.
Use the drop-down menu to select a condition from the list (equals, does not equal, and so on). See Specify Criteria for Selecting Rows.
4.
Type the search value. To search for missing values, leave the box empty.
5.
Click OK.
You can also specify the following optional features:
•
To compare the values of two columns, click the Compare column check box. Select from the list of columns for comparison.
•
To make the search case-sensitive, click the box beside Match Case.
If you currently have rows selected in the data table, you can specify the following optional features:
•
Click an option under Current Selection to tell JMP how to handle that current selection:
–
Clear removes the highlight from currently selected rows and selects all rows that contain the specified value.
–
Extend keeps the currently selected rows selected and also selects the rows in which the specified value has been found.
–
Restrict selects the rows in the currently selected array that contain the specified values.
•
Click Add Condition to add a condition to the list.
•
To add more conditions to the search, repeat the previous steps. Click the appropriate item in the Select Rows area to specify if you would like JMP to select rows conditionally: if all conditions are met, or if any of the conditions are met.
•
To keep the window open after you click OK, select Keep dialog open.

Previous
 • 
Next
Help created on 9/19/2017