Deleting Duplicates in the same column

  • Thread starter Thread starter AlexanderG
  • Start date Start date
A

AlexanderG

Hello,

I have a column of information, rows and rows of numbers to be exact.

I'm aware that there are rows throughout the column that are duplicat
(have the same numeric value). I'm trying to delete all dupes so I ca
go ahead and use the numbers that aren't dupes.

Can anyone here help me with somekind of function that would do this?

Not sure if I'm being clear here, so if you need more explanation I'l
try to provide... Thanks.

Alexander
 
Here's something that may help. It's probably not exactly what you'r
looking for, but I've done similar work by doing this...

Note: I've only gotten this to work with a header row

Highlight the column in question, sort them and copy them to somewher
else. Then go to Data>Filter>Advanced Filter. Click on the Copy t
another location button, then choose the top cell in the targe
location in the "Copy to" field. Check the "Unique records only", the
click OK. That should do what you're asking
 
Thanks! It worked! BTW, I noticed you're in Austin... I'm in Templ
TX.

Have a good one
 
Back
Top