Or you can delete the duplicate values in one go using Remove Duplicates dialog box. To highlight the duplicates in a table or in a range, at first select the whole Table or whole range. To select a table, just click any cell in the table and then press CTRL-A twice.
Every 2nd Thursday our team has to produce reports from data provided to us in a Excel spreadsheet. Typically this data has about 23,000 rows of data.
The problem is that since June these spreadsheets now have duplicated rows, due to a problem in the data warehouse they’re produced in. I don’t understand anything about that side of thing, but what I do know is that we need to find an easy way to delete every second row. At present we are splitting the data into 3 spreadsheets and I have 3 staff members deleting every 2nd row in their respective spreadsheet. When they’re all finished we merge them back into one spreadsheet to produce our reports. This is a big time waster (it still takes hours to do), creates a lot of stress due to other work getting delayed, and ruins morale in the team. We’re using Excel 2011 on iMacs running El Capitan, so I was thinking that a macro could do this, right?
Can someone confirm if this is the case and if yes how we would go about it? This answer assumes:. you have a header row and, because of that, the first row containing your data is Row 2. Solution. Open the Excel spreadsheet in its original state (i.e.