Thread: How do I get the unique values from a column in excel?
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Durgesh M Durgesh M is offline
external usenet poster
  
Posts: 1
Default How do I get the unique values from a column in excel?
I have numbers in one column (Position Control Numner) of sheet A(1000 rows),
I want in another sheet (Sheet B) the unique numbers from the column
(Position Control Numner). Plesae guide me how to achieve this functionality.
I tried advanced filed with unique values option but the output is limited to
the same sheet sheet A.
Reply With QuoteReply With Quote