Delete column A and you will be left with the unique list only. You now have a list of the criteria that was set for the first filtered column. You can repeat the steps for the additional filtered columns and just place them in adjacent columns. Copy the unique list to a blank sheet in your other workbook.

You can quickly filter data based on visual criteria, such as font color, cell color, or icon sets. And you can filter whether you have formatted cells, applied cell styles, or used conditional formatting. • In a range of cells or a table column, click a cell that contains the cell color, font color, or icon that you want to filter.

• On the Data tab, click Filter. • Click the arrow in the column that contains the content that you want to filter. • Under Filter, in the By color pop-up menu, select Cell Color, Font Color, or Cell Icon, and then click a color. • Click a cell in the range or table that you want to filter. • On the Data tab, click Filter. • Click the arrow in the column that contains the content that you want to filter.

• Under Filter, click Choose One, and then in the pop-up menu, do one of the following: To filter the range for Click Rows that contain specific text Contains or Equals. Rows that do not contain specific text Does Not Contain or Does Not Equal. • In the box next to the pop-up menu, enter the text that you want to use. • Depending on your choice, you may be offered additional criteria to select: To Click Filter the table column or selection so that both criteria must be true And. Filter the table column or selection so that either or both criteria can be true Or.

• Click a cell in the range or table that you want to filter. • On the Data toolbar, click Filter. • Click the arrow in the column that contains the content that you want to filter. • Under Filter, click Choose One, and then in the pop-up menu, do one of the following: To filter for Click The beginning of a line of text Begins With. The end of a line of text Ends With. Cells that contain text but do not begin with letters Does Not Begin With.

Cells that contain text but do not end with letters Does Not End With. • In the box next to the pop-up menu, enter the text that you want to use. • Depending on your choice, you may be offered additional criteria to select: To Click Filter the table column or selection so that both criteria must be true And.

Word for mac free. After the license validates, it will activate the product, and you can click Start Using Word to open and start using Office for Mac. Multiple licenses and key already used error? If you try to activate a one-time install of Office for Mac and you get the error: Key already used, you will need to select another license to use.

Filter the table column or selection so that either or both criteria can be true Or. Wildcard characters can be used to help you build criteria. • Click a cell in the range or table that you want to filter. • On the Data toolbar, click Filter. • Click the arrow in the column that contains the content that you want to filter.

• Under Filter, click Choose One, and select any option. • In the text box, type your criteria and include a wildcard character.

For example, if you wanted your filter to catch both the word 'seat' and 'seam', type sea? • Do one of the following: Use To find? (question mark) Any single character For example, sm?th finds 'smith' and 'smyth' * (asterisk) Any number of characters For example, *east finds 'Northeast' and 'Southeast' ~ (tilde) A question mark or an asterisk For example, there~? Finds 'there?' Do any of the following: To Do this Remove specific filter criteria for a filter Click the arrow in a column that includes a filter, and then click Clear Filter. Remove all filters that are applied to a range or table Select the columns of the range or table that have filters applied, and then on the Data tab, click Filter. Remove filter arrows from or reapply filter arrows to a range or table Select the columns of the range or table that have filters applied, and then on the Data tab, click Filter.