MVSFORUMS.com

[tidda]

This is really stupid. I need to remove duplicates in a column in excel. Does anybody know how to do it ?
There are lots of rows ... nobody sitting around me has an answer !

thanks

[tidda]

ok, had to stop by the HR folks to get an answer They seem to be working extensively in MS Office !

select the rows in the column and Click,

data >> filter >> advanced filter >> check the box for unique records only >> ok

that should do it.

cheers