IF, EXACT, VLOOKUP, CONDITIONAL FORMATTING????

Hello Rachel,

Thank you for your question. Here are three methods to find duplicates or triplicates across multiple sheets in Excel:

1. Combine the Data:

Create a new worksheet (let's call it "Combined").
Copy all the email addresses from column D of each of the three sheets and paste them into column A of the "Combined" sheet.

Identify Duplicates/Triplicates:
In the "Combined" sheet, use the following formula in column B to count the occurrences of each email address:

=COUNTIF(A:A, A1)

Drag this formula down to apply it to all rows.
Flag Duplicates/Triplicates:

In column C, you can use a formula to flag whether an email address appears more than once:

=IF(B1>1, "Duplicate", "Unique")

Drag this formula down to apply it to all rows.

2. Filter or Highlight:
You can use Excel's filtering feature to show only the duplicates/triplicates.

3. Use conditional formatting to highlight the duplicates/triplicates:

Select column A.
Go to Home > Conditional Formatting > New Rule.
Choose Use a formula to determine which cells to format.
Enter the formula:

=COUNTIF($A:$A, A1)>1

Choose a formatting style (e.g., fill colour) and click OK.

This will help you identify and flag the duplicates/triplicates across your sheets.

If you need further assistance, feel free to ask!

Kind regards
Marius Barnard
STL