View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.setup
Christian Christian is offline
external usenet poster
 
Posts: 24
Default how to delete duplicate records in a row

Hi. I was browsing the topics in the forum and most of the things I found are
deleting duplicates involve entire rows. My problem is this, I need to delete
duplicate records by row. For instance, in my example below, I want to
elimate the duplicate "20" under column C so that row 1 would only show 4
records (10, 20, 50 and 30). I'd appreciate any assistance anyonoe can
provide.

A B C D E
10 20 20 50 30
5 5 6 7 8
9 10 11 11 12

Thanks!

Christian