Aug 19 2024 10:48 AM - edited Aug 19 2024 10:52 AM
Hello,
I need to delete mutliple rows from my workbook that have duplicate values in two columns I specify. In the example below, only the fourth row would be deleted, as both columns are duplicates of row 2. Since the C rows have different results they would not be deleted.
ID | Result |
A | X |
B | Y |
A | X |
C | Z |
D | Z |
C | X |
Conversely, it would work to copy all rows that have a unique combination in those two rows into a different location.
The most efficient solution would be preferred as my workbook is a couple thousand rows tall, and I would really prefer not to do this by hand. Let me know if I need to clarify anything. Thanks!
Aug 19 2024 12:12 PM