Forum Discussion
SOLVED Finding rows that have the same cells, just in a different order? Microsoft 365
- Oct 14, 2021
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.
- Yea_SoOct 15, 2021Bronze Contributor
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
- Sara970Oct 14, 2021Copper ContributorI'm amazed. Thank you so so much!