Hi,

I require only one instance of a duplicate to be highlighted (Part 1 - below) and counted (Part 2 - below).

I have a Data Table of numbers that span many ROWS by eight COLUMNS. First Row number is 26, Columns C to J. Each Row of eight numbers needs to be checked for a "unique match" against a Named Range: Pass_Mark that spans one Row by eight Columns($I$9:$P$9). The Pass_Mark range will always contain "unique numbers" only.

Data Table range starts Row 26-350, Columns C to J
Pass_Mark range starts Row 9, Columns I to P

Part 1) Using Conditional Formatting:
Condition 1
=D26=C26 to highlight cell pattern and text in white to blank out one instance of all duplicate numbers in the Rows (so the highlighted numbers match the total count for each Row in Part 2).

Condition 2
=COUNTIF(Pass_Mark,C26) to highlight in orange any numbers in my Data Table that match with any of the eight numbers in Named Range Pass_Mark ($I$9:$P$9).

Example:
Pass_Mark range Row 9, Columns I J K L M N O P
60 65 70 75 80 85 90 95

Data Table Row 26, Columns C D E F G H I J M
70 75 60 70 80 70 60 70 4


Part 2) Row 26 Column M contains SUM and COUNT value of "unique matched numbers" from Data Table Row 26 matched to Pass_Mark range Row 9.

Desired Result:
Part 1) To avoid using Condition 1 where I blank out one instance of a duplicate number, is there a Formula that can be used in Conditional Formatting to actually highlight only one instance of a duplicate number in each Row of my Data Table that also matches a separate range of data as my Pass_Mark range.

Part 2) I need to Sum and Count each "unique match" in each Row of my Data Table that matches Named Range Pass_Mark ($I$9:$P$9). This Formula will be entered in Row 26, Column M. Must count each "unique match" and NOT unique numbers in each Row. Using the Example Data the answer/ value in Row 26, Column M should be 4.

Thanks
Tinä