GiacTorrence
New Member
- Joined
- Dec 2, 2014
- Messages
- 40
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:
<tbody>
</tbody>
Thank you!
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!
