Skip to main content
It looks like you're using Internet Explorer 11 or older. This website works best with modern browsers such as the latest versions of Chrome, Firefox, Safari, and Edge. If you continue with this browser, you may see unexpected results.

FIU Digital Project Guidelines and Help Materials

The internal standard operating procedures for FIU Libraries' digital collections

Finding Duplicate Values in the Same Column

Using this technique you can identify duplicate values within the same column. The formula described below compares the value in a row to the row above it and generates either a "same" designation or a "different" designation allowing you the quickly determine duplicate values.

1. Select the column you would like to identify duplicate values in. Use the Sort values from A-Z function.

2. In another column, enter the formula: =IF(B1=B2,"Same","Different"). The letter is the column in which in you are comparing values, and the number is the row # you are comparing.

3. Drag the formula down the column to apply the formula for all values.

Finding Duplicates in 2 Different Columns

1. Select Both Columns.

2. From the Home Tab, select Conditional Formatting > Highlight Cell Rules > Duplicate Values.

3. Duplicate Values will be highlighted.