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

Tagged with

#Excel alternatives for data analysis
#generative AI for data analysis
#natural language processing for spreadsheets
#financial modeling with spreadsheets
#rows.com
#big data management in spreadsheets
#conversational data analysis
#Excel compatibility
#real-time data collaboration
#intelligent data visualization
#data visualization tools
#enterprise data management
#big data performance
#Excel alternatives
#data analysis tools
#data cleaning solutions
#Current Column
#New Column
#duplicates
#data entry