help with this formula!

**se7en7a** · 01-04-2007, 05:43 PM

I have a spreadsheet that I am creating. This is an example:

A1(cell)

xyz
abc
def
def
xyz
abc
wer
xyz
wer

I would like to make a column that has each part listed once. Example

xyz
abc
def
wer

thanks in advance

**VBA Noob** · 01-04-2007, 05:49 PM

Hi,

This link should help

http://www.contextures.com/xladvfilter01.html#FilterUR

VBA Noob

**se7en7a** · 01-04-2007, 06:38 PM

I, is another way to do that?
it dont work for me because i need to fill again the colun A1, and the sort dont work after that, i have to do the sort again.

thanks

**VBA Noob** · 01-04-2007, 06:50 PM

Hi,

Try ths formula. It's an array so enter with Ctrl + Shift + Enter

=IF(ISERROR(INDEX($A$1:$A$10,SMALL(IF(ROW($A$1:$A$10)=MATCH($A$1:$A$10,$A$1:$A$10,0),ROW($A$1:$A$10)),ROW()))),"",(INDEX($A$1:$A$10,SMALL(IF(ROW($A$1:$A$10)=MATCH($A$1:$A$10,$A$1:$A$10,0),ROW($A$1:$A$10)),ROW()))))

VBA Noob

**se7en7a** · 01-05-2007, 04:21 AM

Hi,
i try , but the result is a blank cell.
Am I doing something wrong?

**VBA Noob** · 01-05-2007, 04:32 AM

Try this.

Range in formula needs to be the same as range with values

VBA Noob

**starguy** · 01-05-2007, 06:46 AM

Originally Posted by se7en7a

I have a spreadsheet that I am creating. This is an example:

A1(cell)

xyz
abc
def
def
xyz
abc
wer
xyz
wer

I would like to make a column that has each part listed once. Example

xyz
abc
def
wer

thanks in advance

Hi
look the file attached here for answer to your problem.