# ModifiedDuplicate Formula

#### GiacTorrence

##### New Member
Hi all,

I'm trying find a slightly modified formula for detecting duplicate values across rows/columns. I would like to make sure that the first two rows are equal, and the latter two rows are equal (as pairs). I've been using this formula:=IF(FREQUENCY(A1:D4,A1:D4)=4,"dup","notdup"), which seems to work well when applied to the first and second rows, but when applied to the third and fourth, it will identify the data as not being duplicate. I'm guessing that's due to the space in between.

Is there a formula that might be able to correct for this? Here is what my data look like:

 4 4 4 4 4 4 4 4 5 5 5 5 5 5

<tbody>
</tbody>

Thank you!

### Excel Facts

Save Often
If you start asking yourself if now is a good time to save your Excel workbook, the answer is Yes

Replies
1
Views
295
Replies
1
Views
123
Replies
1
Views
401
Replies
1
Views
103
Replies
1
Views
148

1,203,521
Messages
6,055,885
Members
444,830
Latest member

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back