Lesson 228: Find the same value in Excel

This article will guide you to find the same value in Excel.

Find the same value

This article will guide you to find the same value in excel

Two values

Find the same value in excel

1. Select range A1:C10

2. On the Data Tab Select Conditional Formatting

3. Select Highlight Cells Rules, Duplicate Values.

4. Select formatting style and click OK

Result

Three values.

1. Select range A1:C10

2. On the Data Tab Select Conditional Formatting

3. Select new rule

4. Select Use a formula to determine which cells to format

5. Enter the formula =COUNTIF($A$1:$C$10,A1)=3

6. Select formatting style and click OK

Result

Two lines

1. Select range A1:C10

2. On the Data Tab Select Conditional Formatting

3. Select new rule

4. Select Use a formula to determine which cells to format

5. enter formula =COUNTIFS(Animals,$A1,Continents,$B1,Countries,$C1)>1

6. Select formatting style and click OK

In addition, you can also see many other excel articles here.