Forum Discussion
SOLVED Finding rows that have the same cells, just in a different order? Microsoft 365
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.
The narrative says:
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.
it got rid of the spouse relationship which was not a repetition:
how did that solve your problem?
Ideally, the relationship description should reflect the "Subscriber" if not obvious like the Employer/Employee relationship is obvious.
cheers
- I'm amazed. Thank you so so much!
