addicted Posted January 27, 2009 Share Posted January 27, 2009 I've got a worksheet with 2000 names in Column A. The range is A1:A2000 The names repeat throughout the list. Can anyone tell me how to quickly delete all of the duplicate names and just leave the unique names? What's the formula to do that? I've tried things like =UNIQUE(A1:A2000) but that didn't work, help please! Link to comment Share on other sites More sharing options...
This topic is now archived and is closed to further replies.