Hello all Excel experts and members,
I would like to find duplicate value for big data simultaneously. However, it would be time consuming and ineffective if I do it column by column.
I hope some of the Excel expert can give me some advice. Below are portion of the sample data:
<tbody>
</tbody>
I would be expecting the following outcome:
<tbody>
</tbody>
Many thanks.
I would like to find duplicate value for big data simultaneously. However, it would be time consuming and ineffective if I do it column by column.
I hope some of the Excel expert can give me some advice. Below are portion of the sample data:
Day 1 | Day 2 | Day3 |
25 | 25 | 25 |
30 | 25 | 30 |
30 | 25 | 35 |
25 | 30 | 30 |
<tbody>
</tbody>
I would be expecting the following outcome:
Day 1 | Day 2 | Day 3 |
Duplicate | Duplicate | Unique |
Duplicate | Duplicate | Duplicate |
Duplicate | Duplicate | Unique |
Duplicate | Unique | Duplicate |
<tbody>
</tbody>
Many thanks.