Most valuable professional
  • Hot Topics

Excel Extract Unique Values

Hello everybody I have data in range (A1:A5) the value A and in range(A6:A10) the value B and in range(A11:A15) the value C Three values in column A : A,B and C In column B different values A A A A A B B B B B C C C C C I want to extract unique values of Column A to Column E The result should be : E1 : A E2: B E3: C In F1 ,G1 and H1 the values should be : s f d In F2 , G2 ,H2, I2 and J2 the values should be : r q u t x In F3,G3,H3 and I3 the values should be: n m k p

This question generated 14 answers. To proceed to the answers, click here.

This thread is current as of October 13, 2014.

For more resources for Microsoft Excel:

This article includes the following tags:

  • Excel
  • Microsoft Excel