Hello All,
I have several column pairs of data.
Each is a pair of columns with Date + Event.
They go on in a table for 100s of rows and 100s of pairs of columns.
Here's just an example of two column pairs (keeping in mind other pairs would continue to the right --> and the columns themselves have way more entries:
<tbody>
</tbody>
Sometimes there are repeat entries, for ex in the red text area.
Right now I can remove duplicates manually
by selecting each column pair together and just clicking the remove duplicates button.
This works fine, but this is tedious.
Is there a way to automate remove duplicates
for each column pair on the entire sheet?
Any help is greatly appreciated!
I have several column pairs of data.
Each is a pair of columns with Date + Event.
They go on in a table for 100s of rows and 100s of pairs of columns.
Here's just an example of two column pairs (keeping in mind other pairs would continue to the right --> and the columns themselves have way more entries:
1/1/2001 | AAAA | 1/1/2001 | AAA |
1/2/2001 | BBBB | 1/2/2001 | AAA |
1/2/2001 | BBBB | 1/3/2001 | AAA |
1/3/2001 | BBBB | 1/4/2001 | FFF |
1/4/2001 | BBBB | 1/5/2001 | FFF |
<tbody>
</tbody>
Sometimes there are repeat entries, for ex in the red text area.
Right now I can remove duplicates manually
by selecting each column pair together and just clicking the remove duplicates button.
This works fine, but this is tedious.
Is there a way to automate remove duplicates
for each column pair on the entire sheet?
Any help is greatly appreciated!