I am using Excel 2010. I have merged 2 excel sheets. It has over 2000 line of data but a much of the data is repeated by not needed. I want a way if the data on line 35 matches 36 for first 3 cells A, B,C is the same delete both line 35 & 36. Please help instead of having to go line by line.
Thanks Dirk
Select columns A, B, and C, click Remove Duplicates
Microsoft MVP - Excel
Entia non sunt multiplicanda sine necessitate
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks