highlight duplicate rows and delete based on highest value from column
Hi,
i want VBA to
1)highlight duplicate rows based on Column A and column B.
2)and delete row between duplicates based on highest value between them from (column C)
my Data contains:
Date ID Value
03/02/15 MC 1797 10
03/02/15 MC 1728 12
03/02/15 MC 1404 13
03/02/15 MC 1797 17
i want VBA to highlight row1 and row4.and after that delete row4 because of highest value.
please help ASAP.
Thanks
Hi,
Please find the below VBA code which will help to delete the duplicate rows:-
Sub duplicate() Dim rng As Range Lastrow = Worksheets("Sheet1").Cells(Rows.Count, 1).End(xlUp).Row With ActiveSheet Set rng = Worksheets("Sheet1").Range("A1:C" & Lastrow) rng.RemoveDuplicates Columns:=3, Header:=xlYes End With
Thanks
Nisha Dhawan
If you like my answer please click on * Add Reputation
"If you can dream it, You can do it"
Hi
Nisha Thanx for your help,but code is not working.can u please check it once.
Hi,
While applying this code please make sure that worksheet name and data range should be according to your data.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks