•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Highlighting duplicates from two different worksheets, but only when all of the data in a row matches
Our take
If you’re looking to highlight duplicates across two worksheets based on a complete row match, you’re not alone. Many users encounter challenges when trying to compare data across multiple columns. In your case, you want to ensure that if all entries from columns A to E on Sheet 1 match those on Sheet 2, they are highlighted. This method prevents any overlap of old data with your fresh entries. Let's explore a straightforward solution that can streamline this process and enhance your data management.
Hey guys. Sorry to post such a random question. Essentially, I've got two sheets I'm working off. The jist is on sheet 1 I've got new fresh data, on sheet 2 I've data from a few years back.
Essentially, I want to paste in the old data into sheet 2 and have it highlight on sheet 1 if the data matches everything columns A through E on each so that it isn't used again.
I've tried everything I can think of, and I'm probably missing something really obvious. I get Too Many Arguments error, or it only matches data on a single column.
Can anyone point me in the right direction as I'm pulling my hair out over this.
Much appreciated
[link] [comments]
Read on the original site
Open the publisher's page for the full experience
Tagged with
#Excel alternatives for data analysis#big data management in spreadsheets#generative AI for data analysis#conversational data analysis#real-time data collaboration#intelligent data visualization#data visualization tools#enterprise data management#big data performance#data analysis tools#data cleaning solutions#rows.com#Excel compatibility#google sheets#Excel alternatives#row zero#highlighting#duplicates#data#worksheets