The Unique Extractor for Microsoft Excel quickly and easily determines the number of occurrences, frequency and rank of the entries in a column or a selection of a column, as illustrated by the following sample analysis of a worksheet:

In addition to doing the above analysis, the Unique Extractor can extract rows from a worksheet based on an IF test. Just select the range to be searched and then fill in the following dialog.  Options allow one to enter in a search entry or to specify a set of cells whose values will be used to do the search

Output options on the IF test search allow you to any or all of the following:

• Color matching source rows
• Insert a marking entry in a column of your choice
• Copy the matching rows to a new worksheet.

With the Unique Extractor, you can quickly extract the data of interest and spend time working on it instead of searching for it.