Forum Discussion
Solved
SOLVED Finding rows that have the same cells, just in a different order? Microsoft 365
Hi, I have a list of names, IDs, and relationships. Many of the relationships are listed twice, as the reciprocal. I'm trying to get rid of the rows that list the same relationship again. Is ther...
See the attached version. I added a formula in column I that specifies the rows that can be deleted.
Filter column I for TRUE, delete all rows from row 2 down, then remove the filter.
See the attached version. I added a formula in column I that specifies the rows that can be deleted.
Filter column I for TRUE, delete all rows from row 2 down, then remove the filter.
I'm amazed. Thank you so so much!