•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
Our take
It seems you're encountering an issue with Excel 2019 where the "Remove Duplicates" function isn't performing as expected for the Non-text and Month columns. You're right to anticipate seeing one row with "True" and one with "False," along with no duplicated months. This may be due to how Excel identifies duplicates, including hidden characters or formatting inconsistencies. Ensure that both columns are formatted consistently and check for any hidden spaces. Exploring these factors may lead to the desired outcome in your data management process.
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]
Read on the original site
Open the publisher's page for the full experience
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