Select Copy to another location...in List Range select your list of duplicated data...leave Criteria Range blank and in Copy to select a cell in a blank column on your sheet...finally select the Unique records only option.
do the above meet you requirements, are you wanting to extract a unique list to work with or "delete" the duplicates, using advanced filter wont actually delete them just filter them out, you could use this method to get a unique list then delete the origonal list or follow the link for more options on duplicates, read the part whicha says delete rows
All- thanks for the replys. I did figure it out. However, i do have a new challange: Is it possible to filter on one column when you have data in six columns??
For example; I have data in columns A-F. Column B has the data that i will like to filter out duplicate info but keep all the other columns in tact. Is that possible or is there another way to get what i need. Thanks in advance!
Dim Rng As Range
Dim i As Long
i = Range("A" & Rows.Count).End(xlUp).Row
Set Rng = Range("B1:B" & i)
.AdvancedFilter Action:=xlFilterInPlace, Unique:=True
Selection.EntireRow.Hidden = True
.EntireRow.Hidden = False