stylencia18
New Member
- Joined
- Aug 14, 2017
- Messages
- 31
Good afternoon:
I have 10,000 rows of data and I want to search for duplicate rows but I don't know how to. I do NOT want to delete duplicates, just highlight them.
Sample spreadsheet:
<tbody>
</tbody>
I have 10,000 rows of data and I want to search for duplicate rows but I don't know how to. I do NOT want to delete duplicates, just highlight them.
Sample spreadsheet:
<tbody> </tbody> We can easily see that the 1stand 3rd rows are duplicates. How do I find duplicates in 10,000 rows of data? In order to be a duplicate, the following column names must match exactly: Date; Code; Patient ID Number Thank you!!! |
<tbody>
</tbody>