Sample type: Duplicate value sample
Parameters: Case insensitive
Description: Shows all duplicate values from the population
To generate the sample, perform the steps:
Select the region of the population and click the Generate sample
button.
Enter Sheet name. If you do not enter a name, the program will
automatically name it Sample, Sample 1, Sample 2, etc.
In the Sample type drop-down menu, select Duplicate value
sample.
If necessary, change the population region in the Range field by
clicking the ''...'' button.
In the Value column drop-down menu, select the column that the
values will be taken from.
Mark whether the region includes headers.
In the Parameters section, mark the Case insensitive option
if you want to remove the difference between upper and lower case in
identical words:
Example: the program will treat register and Register as one
and the same word