formula or macro?

[bigK]

I'm trying to populate a worksheet (column A) with part numbers from a previous worksheet the only problem i have is that on the original there are multiples of the same thing and i want to only show one of them (if there are multiple)

would a formula or a macro be best for this ... and what form would either a formula or macro take

cheers

 

[QuietRiot]

i would use VBA

Sub DeleteDups() 
     
    Dim x               As Long 
    Dim LastRow         As Long 
     
    LastRow = Range("A65536").End(xlUp).Row 
    For x = LastRow To 1 Step -1 
        If Application.WorksheetFunction.CountIf(Range("A1:A" & x), Range("A" & x).Text) > 1 Then 
            Range("A" & x).EntireRow.Delete 
        End If 
    Next x 
     
End Sub

you want to get rid of duplicates in column A correct?

 

[Aladin Akyurek]

I'm trying to populate a worksheet (column A) with part numbers from a previous worksheet the only problem i have is that on the original there are multiples of the same thing and i want to only show one of them (if there are multiple)

would a formula or a macro be best for this ... and what form would either a formula or macro take

cheers

Run Data|Filter|Advanced Filter on the data from within the destination sheet with "Unique records only" checked...

 

[QuietRiot]

I'm trying to populate a worksheet (column A) with part numbers from a previous worksheet the only problem i have is that on the original there are multiples of the same thing and i want to only show one of them (if there are multiple)

would a formula or a macro be best for this ... and what form would either a formula or macro take

cheers

Run Data|Filter|Advanced Filter on the data from within the destination sheet with "Unique records only" checked...

that works too, only that doesn't delete them

easier for you if your not familiar with code though