Removing duplicate entries

[jei eusebio]

Hi Ninjas,

I have a list of names in column B which has a lot of duplicates and I want to have another list of names in column D containing only the unique values. I followed some steps I saw online .. I created a helper column (column A) put "1" in cell A3 then used the formula =IF(COUNTIF($B$3:B3,B3)=1,A3+1,A3) and dragged it down up to the last cell with name in it. Then in column D I used =IFERROR(VLOOKUP(ROW()-1,$A$3:$B$1048576,2,FALSE),"") to create the list without duplicate values, but after double checking there were some names not included in the list as the first formula counted them under the previous name.
Unable to post screenshots due to restrictions here in the office. Just pasted the values below. Thanks in advance guys!


35Bowls, Elizabeth
36Bowls, Elizabeth
36Bowls, Elizabeth
36Bowls, Elizabeth
36Bowls, Elizabeth
36Bowls, Elizabeth
36Bowls, Elizabeth
36Bowls, Elizabeth
36Briones, Monica
37Britton, Amanda
38Britton, Amanda
38Britton, Amanda
335Marshall, Eleanora
335McKinney, Justin

 

[Somendra Misra]

Hi,

Well a helper cell or an array formula will definitely will give you results, but why not try pivot table or if this is a one-time activity than copy the values in column D and use remove duplicate feature from Data tab.

Regards,

 

[jei eusebio]

Hi Somendra,

I'm unable use a pivot table coz' beside the names would be lookup values from other sheets that contain their schedules.

 

[NARAYANK991]

Hi ,

Your formula in A4 should be :

=IF(COUNTIF($B$3:B4,B4)=1,A3+1,A3)

Narayan

 

[jei eusebio]

Hi Narayan,

Thanks! It worked but now i think my problem now is with the second formula coz' it doesn't get the first name in the list. LoL :D

 

[jei eusebio]

Hi Narayan,

All good now. retyped the 2nd formula, might have just missed something awhile ago hehe .. Thanks guys!