Example of subsetting a worksheet based on a formula

Suppose a worksheet contains a column of part numbers that include text and numbers. A manager wants to subset the worksheet to include only the rows that start with the letters "win" and end with "s".

Choose File > New > Worksheet.
In the C1 column name cell, enter Part.
Copy and paste, or type the following data into the Part column:

win322s

prn23s

tts987s

win753s

prn324m

win543m

qlt591m

win456m
Choose Data > Subset Worksheet.
From How do you want to create a subset?, select Use formula.
From Do you want to include or exclude rows?, select Include rows that match the condition.
In Formula, copy and paste, or enter LEFT(C1,3)="win" And RIGHT(C1,1)="s"
Note
If you want to subset using both capital and lowercase letters (for example, win, Win, WIN), include the LOWER function, for example, LEFT(LOWER(C1),3)="win". For more information, go to Calculator functions.
Click OK.

Results

Minitab creates a new worksheet that contains only the data for parts that begin with "win" and end with "s".

C1-T
Part
win322s
win753s

Example of subsetting a worksheet based on a formula

Note

Results