•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Remove Duplicates doesn't work as expected
Why is selecting to remove duplicates from the Non-text and Month columns only removing two duplicates? There are still duplicates in both columns.
I'm expecting one row with "True" and one row with "False" to be displayed, and no rows with duplicated months.
EDIT: I'm using Excel 2019. Thanks in advance.
[link] [comments]
Want to read more?
Check out the full article on the original site
Tagged with
#financial modeling with spreadsheets
#rows.com
#Excel compatibility
#row zero
#Excel alternatives for data analysis
#Excel alternatives
#remove duplicates
#Excel 2019
#duplicates
#Non-text
#Month
#columns
#row
#deduplication
#True
#False
#data cleaning
#data integrity
#displayed
#Excel functionality