Excel: Selective duplicates removal

Question

I want to remove some duplicates, but not all. Let me give you an example below:
 A  B
 UK James
 UK Coco
 UK Lydia
 UK Matthew
 US Max
 US Kim
 US Anna
 FR Marie
 FR Lin

I want to turn the columns above into the following:
 C  D 
 UK James
    Coco
    Lydia
    Matthew
 US Max
    Kim
    Lulu
 FR Marie
    Lin

Initially, I tried the 'remove duplicates' option in Excel, but I wanted to have Column A organised as in Column C.  Is there any way to do this?

Hennes · Answer

Assuming A is sorted, then you can use =IF(A2=A1,"",A2)

Basically you compare if the row above it is the same. If it is, shown an empty cell, if it if a different value then show that.

Excel: Selective duplicates removal

One Answer

Add your own answers!

Ask a Question