Note: take a look at the third picture on this page to see that we swapped the last 2 arguments of the IF function. You can also display the unique values in the second column. Note: take a look at the second picture on this page to see that we swapped the last 2 arguments of the IF function.Ģ. Display the unique values in the first column (these values do not occur in the second column). Microsoft Excel's Conditional Formatting feature shows you exactly where duplicates. Unique Values in Each Columnĭo you want to compare two columns by displaying the unique values in each column? Simply swap the last 2 arguments of the IF function.ġ. When working with a Microsoft Excel spreadsheet with lots of data, you'll probably encounter duplicate entries. At step 2, we match each value in the second column with the range in the first column. Note: at step 1, we matched each value in the first column with the range in the second column. You can also display the duplicates in the second column. An example would be Col A: Pin1 Col B: GND. As a result, the ISERROR function returns TRUE and the IF function returns an empty string.Ģ. In some cases the dulpicates are the same signal path in reverse. The MATCH function in cell C4 returns a #N/A error (no letter D in the range B1:B7). As a result, the ISERROR function returns FALSE and the IF function returns the value in cell A1. Display the duplicates in the first column (these values also occur in the second column).Įxplanation: the MATCH function in cell C1 returns the number 5 (letter A found at position 5 in the range B1:B7). Select the New Rule option from the Conditional Formatting button drop-down list. Select the Conditional Formatting button under the Home tab. Select the Conditional Formatting button on the Home tab.
Let's start by comparing two columns and displaying the duplicates.ġ. Click on the Column Header to highlight Column A.
0 kommentar(er)
