Do You Use Excel At School/work? Question For You

Marik_SteeleMarik_Steele To rule in hell... Join Date: 2002-11-20 Member: 9466Members
edited June 2005 in Off-Topic
Simple little question about Microsoft Excel.
Let's say I have a typical spreadsheet. It has a whole lot of names in one column. They are sorted alphabetically (very easy to do in Excel, I know that much.) I want to delete all the duplicates.

How do I do this, or where else can I look it up online?
Off Topic Disagree Agree Awesome

Comments

  • QuaunautQuaunaut The longest seven days in history... Join Date: 2003-03-21 Member: 14759Members, Constellation, Reinforced - Shadow
    Are you looking to replace ANY duplicates, or just specific ones?
    Off Topic Disagree Agree Awesome
  • im_lostim_lost TWG Rule Guru Join Date: 2003-04-26 Member: 15861Members
    Go to Data -> Filter -> Advanced Filter, and when you choose this option, check the "Unique entries only" box. There's other stuff you have to do to make it work well I think. (I think you have to copy it to a different column to get rid of the duplicates rather than hiding them, and I think that requires having a column title formatted differently than the rest of the column. I made a macro to do that a while ago, though the macro also sorted alphabetically first.) It shouldn't be too hard to figure out from there.
    Off Topic Disagree Agree Awesome
Sign In or Register to comment.