New Range containing Unique names only

[Steve]

I have four columns of names that are a named range
called "names". I am looking for some code that will
export only the unique names in the "names" range to ONE
column that I wish to name "unique".

Any help would be greatly appreciated.

Steve

 

[John Green]

Steve,

You can do this using an array formula. Enter the following formula in the
H2 cell as an array (while in edit mode, hold down Ctrl+Shift and press
Enter).

=INDEX(Names,MIN(IF(COUNTIF($H$1:H1,Names)=0,ROW(Names)-MIN(ROW(Names))+1)),
MATCH(0,COUNTIF($H$1:H1,INDEX(Names,MIN(IF(COUNTIF($H$1:H1,
Names)=0,ROW(Names)-MIN(ROW(Names))+1)),,1)),0),1)

Now copy the formula down the page until it starts producing #N/A errors.

John Green
Sydney
Australia

 

[Steve]

John, That Solution worked great !
Thanks Steve

-----Original Message-----
Steve,

You can do this using an array formula. Enter the following formula in the
H2 cell as an array (while in edit mode, hold down Ctrl+Shift and press
Enter).

=INDEX(Names,MIN(IF(COUNTIF($H$1:H1,Names)=0,ROW(Names)- MIN(ROW(Names))+1)),
($H$1:H1,
Names)=0,ROW(Names)-MIN(ROW(Names))+1)),,1)),0),1)

Now copy the formula down the page until it starts producing #N/A errors.

John Green
Sydney
Australia




.