Auditdesktop help

Sample type: Duplicate value sample

Parameters: Case insensitive

Description: Shows all duplicate values from the population

Generation

To generate the sample, perform the steps:

  1. Select the region of the population and click the Generate sample
    button.

  2. Enter Sheet name. If you do not enter a name, the program will
    automatically name it Sample, Sample 1, Sample 2, etc.

  3. In the Sample type drop-down menu, select Duplicate value
    sample
    .

  4. If necessary, change the population region in the Range field by
    clicking the ''...'' button.

  5. In the Value column drop-down menu, select the column that the
    values will be taken from.

  6. Mark whether the region includes headers.

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

  1. Click the Generate button.