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".

  1. Choose File > New > Worksheet.
  2. In the C1 column name cell, enter Part.
  3. Copy and paste, or type the following data into the Part column:
    win322s
    prn23s
    tts987s
    win753s
    prn324m
    win543m
    qlt591m
    win456m
  4. Choose Data > Subset Worksheet.
  5. From How do you want to create a subset?, select Use formula.
  6. From Do you want to include or exclude rows?, select Include rows that match the condition.
  7. 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.

  8. 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
By using this site you agree to the use of cookies for analytics and personalized content.  Read our policy