•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".
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]
Want to read more?
Check out the full article on the original site
Tagged with
#rows.com
#AI formula generation techniques
#formula generator
#Excel compatibility
#cloud-based spreadsheet applications
#Excel alternatives for data analysis
#Excel alternatives
#duplicates
#columns
#formula
#coordinate pair
#identify
#combination
#values
#rows
#display
#correct
#combined
#reliably
#test