Thread: [Solved] Macro to Delete Duplicate Rows and Retain Unique Value
View Single Post
 
Old 02-17-2014, 11:00 AM
expert4knowledge expert4knowledge is offline Windows 7 32bit Office 2010 32bit
Advanced Beginner
  
Join Date: Apr 2012
Posts: 59
expert4knowledge is on a distinguished road
Default Macro to Delete Duplicate Rows and Retain Unique Value
I have a worksheet that contains many rows of data. In certain instances there may be several consecutive rows of data that have duplicate values in one column for example column A which is the id of students in column A and their costs in other columns, but each student may have the ID in different rows and so column A has duplicate values, I need a macro that can delete duplicates and retain one value, thanks in advance
Reply With Quote