![]() In cell C1 use the Countif formula countif(B2:B2,B2) to get the count of the first. Application.ScreenUpdating False ' Get count of records to search through (list that will be deleted). Sub DelDupsTwoLists () Dim iListCount As Integer Dim iCtr As Integer ' Turn off screen updating to speed up macro. In Google Sheets, theres nothing like Excels Go To Special feature. ![]() I'd like to know if there is a better way of doing this when instead of 3 columns there are about 18 columns and 10,0000 rows. Go to Data then select the Remove Duplicates option in the Data Tools group. Non-Array Formula to Delete Duplicates But Keep the Corresponding Rows 1. To use the macro, select either sheet, and then run the macro. If (ActiveSheet.Range(current).Value = ActiveCell.Value) And (ActiveSheet.Range(current).Offset(0, 2).Value = ActiveCell.Offset(0, 2).Value) And (ActiveSheet.Range(current).Offset(0, 3).Value = ActiveCell.Offset(0, 3).Value) ThenĪctiveSheet.Range(current).Offset(1, 0).Activateīasically, using the example I've linked above, this is meant to go through the entire rows down the columns, and if there are entire rows that are the same, one of the duplicates is deleted. Instructions to run the VBA Macro code to delete duplicate rows in Excel Step 1: Open any Excel workbook Step 2: Press Alt+F11 This will open the VBA Editor. I can't really write any codes, but I've tried using the following: Sub DeleteDuplicate() I've been searching for a while but haven't really found an answer, so I thought I'd post.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |