Forum Discussion
Remove Duplicates Feature: All columns must meet all criteria?
It deletes rows based on the columns you have selected. i.e. it looks for duplicates based on the combination of the columns you have selected.
If you have this list: and you select to delete only by the ID column then the bottom row will be removed (1 | Johnny). The remove duplicates process keeps the first instance from top to bottom and removes items below:
ID Name 1 Matt 2 John 3 Gary 1 Johnny If we have data like the below and we want to delete based on ID and Name columns. The process will only remove the last record (1 | Matt).:
ID Name 1 Matt 2 John 3 Gary 1 Jerome 1 Matt Here are a few articles that describe it:
https://support.office.com/en-us/article/find-and-remove-duplicates-00e35bea-b46a-4d5d-b28e-66a552dc138d
https://www.quora.com/When-you-remove-duplicates-on-excel-does-it-remove-them-from-top-or-bottom
Hope this helps.
It deletes rows based on the columns you have selected. i.e. it looks for duplicates based on the combination of the columns you have selected.
If you have this list: and you select to delete only by the ID column then the bottom row will be removed (1 | Johnny). The remove duplicates process keeps the first instance from top to bottom and removes items below:
| ID | Name |
| 1 | Matt |
| 2 | John |
| 3 | Gary |
| 1 | Johnny |
If we have data like the below and we want to delete based on ID and Name columns. The process will only remove the last record (1 | Matt).:
| ID | Name |
| 1 | Matt |
| 2 | John |
| 3 | Gary |
| 1 | Jerome |
| 1 | Matt |
Here are a few articles that describe it:
https://support.office.com/en-us/article/find-and-remove-duplicates-00e35bea-b46a-4d5d-b28e-66a552dc138d
https://www.quora.com/When-you-remove-duplicates-on-excel-does-it-remove-them-from-top-or-bottom
Hope this helps.
Super helpful! Thanks so much.
-Justin
You're welcome. Please feel free to post back to the community if you have additional inquiries. Always happy to help.