Columns(1), 0) Thenĭ = Application.CountIfs(.Columns(1). Key2:=.Columns(2), Order2:=xlDescending, _ĭ = Application.CountIfs(.Columns(1). Cells.Sort Key1:=.Columns(1), Order1:=xlAscending, _ You have indicated that column A was sorted it seems to me that both column A and column B should be sorted with column A as the primary key and column B as the secondary key. 'compare this A to the one above if they are the same, merge the cells in both columns If the data set doesn’t have a header row, you don’t need. In the Consolidate window, check Top row, and Left column and click OK. Select the data range you want to consolidate (e.g., B1:C17), and press ENTER. 'get the values of A for this row and the one before In the Consolidate window, leave the default Function ( Sum ), and click on the Reference icon to select the range for consolidation. If i > 1 Then 'only compare if this is not the first row - nothing to look backwards at! 'variables to store the value in A in a row and its upstairs neighbor Select the next cell you want to combine and press enter. Type & and use quotation marks with a space enclosed. Type and select the first cell you want to combine. 'disable alerts to avoid clicking OK every time it merges Combine data with the Ampersand symbol (&) Select the cell where you want to put the combined data. I have added another column named “ Count”.I've done this a few times. The COUNTIF function will count the duplicate numbers and then from that, we’ll be able to detect the duplicate rows. Here we’ll use only the COUNTIF function to find duplicate rows in Excel. Method 3: Insert COUNTIF Function to Find Matched Rows in Excel Read more: How to Find & Remove Duplicate Rows in Excel This method is a bit easier because it will not need any helper column like the previous method. In this method, we’ll again use Conditional Formatting. Read more: Excel Find Duplicate Rows Based on Multiple Columns Excel will highlight the duplicate rows.Following that, select Highlight Cell Rules.After that, select Conditional Formatting.After that, use Fill Handle to AutoFill up to D12.Then hit the Enter button to get the output.

Merge duplicate rows in excel 2007