Use

to copy specified rows from the active worksheet to a new worksheet. You can specify the subset based on values in a column, formatted cells in a column, brushed points on a graph, and more.If the worksheet contains columns of different lengths, you can choose to include all columns or only columns that are the same length.

Subset Worksheet copies columns to the new worksheet, but not stored constants or matrices. To copy stored constants and matrices as well, use the SUBSET session command. If any columns are hidden in the original worksheet, those columns will also be hidden in the new worksheet.

Suppose you want to subset the worksheet to include only the rows that start with the letters "win" in C1.

If you want to subset the worksheet based on a text string in a different position, use the calculator text functions MID or RIGHT.

- Choose .
- In How do you want to create a subset, choose Use formula.
- In Formula, enter
`LEFT(C1,3)="win"`.###### Note

If you want to subset using both capital and lowercase letters (for example, win, Win, WIN), enter

`LEFT(LOWER(C1),3)="win"`. - Click OK.