•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
I want to treat columns E and F as a single coordinate pair. If the same combination of values appears more than once, I want column G to display "Duplicate".
Our take
To effectively treat columns E and F as a single coordinate pair and identify duplicates, you need a reliable formula that checks for repeated combinations of values. Currently, it seems that not all duplicates are being flagged, even after duplicating rows for testing purposes. To resolve this, consider using a formula that concatenates the values from both columns and checks for their occurrences.
I want to treat columns E and F as a single coordinate pair. If the same combination of values appears more than once, I want column G to display "Duplicate".
Currently, only some duplicates are being identified. To test the formula, I duplicated rows 2–10 again in rows 18–26, but several of those duplicates are still not being flagged.
What is the correct formula to reliably identify duplicates based on the combined values of columns E and F?
[link] [comments]
Read on the original site
Open the publisher's page for the full experience