how to delete first instances of a duplicate in Excel

  • Thread starter Thread starter powderskier9
  • Start date Start date
P

powderskier9

Just wondering if anyone knows how to delete first instances of
duplicate in Excel spreadsheet. For example:

Column A Column B Column C
Apple Red
Apple Red Large
Banana Yellow Large
Cherry Red
Cherry Red Small

delete duplicates so I end up with:

Column A Column B Column C

Apple Red Large
Banana Yellow Large
Cherry Red Small

Cheers,

Thanks for your time
 
Hi
if your table is sorted like your example try the following
- in D1 put the formula:
=IF(A2=A1,"X","")
in D2 put the formula
=IF(AND(A2<>A1,A2=A3),"X","")
copy this formula down
- now filter column D (goto 'Data - Filter - Autofilter') and delte all
'X' rows
- delete column D
 
Thank you Frank. Your solution worked great. Your help is greatl
appreciated. Danka
 
Back
Top