View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Cecil
 
Posts: n/a
Default Unique Values Only


Given a long column of values, how do I extract only unique values?
Small example Values of 1, 2, 2, 3, 4, 4, 4, 5 in column A. Would
like to extract unique values ... 1, 2, 3, 4, 5 ... and put them in
another column. Thanks.


--
Cecil
------------------------------------------------------------------------
Cecil's Profile: http://www.excelforum.com/member.php...o&userid=29035
View this thread: http://www.excelforum.com/showthread...hreadid=514051