1 min readfrom Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community

Looking for a way to compare "Current" Column with "New" Column and remove any duplicates.

https://preview.redd.it/3lw1tu3yovwg1.png?width=876&format=png&auto=webp&s=e4d76ab762d1e97338a006ba8aae3a8fb9bb34b2

Looking for a way to compare "Current" Column with "New" Column and remove any duplicates. I need to update incomes and hours for my data entry job and it'll be so much easier if any income and hours that hasn't changed be removed so it's less visual clutter for me... imagine this screenshot but with hundreds of more lines. It's very overwhelming and if the "New" columns match the "Current" columns then I don't even need to worry about it so they might as well be removed.

submitted by /u/sadsadboy1994
[link] [comments]

Want to read more?

Check out the full article on the original site

View original article