automatically extract unique values from a list

try in worksheet module.

Please Login or Register  to view this content.

Thanks for the rep.

As that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED,as per Forum Rule #9. Thank you.

Here's a formula method...

Data Range

	A	B	C
1	Items	-----	Unique Items
2	dog		dog
3	dog		cat
4	dog		elephant
5	cat
6	elephant
7	cat
8
9
10

First, create a dynamic named range...

Goto the menu Insert>Name>Define
Name: Items
Refers to: =$A$2:INDEX($A:$A,MATCH("zzzzz",$A:$A))
OK out

Then, enter this array formula** in C2:

=LOOKUP("zzzzz",CHOOSE({1,2},"",INDEX(Items,MATCH(0,COUNTIF(C$1:C1,Items),0))))

** array formulas need to be entered using the key
combination of CTRL,SHIFT,ENTER (not just ENTER).
Hold down both the CTRL key and the SHIFT key
then hit ENTER.

Copy down to enough cells that will extract the new items as they are added in column A. How many cells that is only you would know!

Are you using Excel 2003 as your profile indicates?

You might also be interested in this thread...

http://www.excelforum.com/excel-prog...pty-cells.html

In Excel 2007...

Goto the Developer tab.

If the Developer tab is not visible...

Click the Office button>Excel Options>Popular
Select: Show Developer tab in the Ribbon
OK out

On the Developer tab...
Select: Insert
In Form Controls, click the button icon

Navigate to where you want the button to appear.

Click and hold the left mouse button and drag to "draw" the button.

When you are done and release the mouse button a menu should appear so that you can select the macro of interest and attach it to the button.

Select the macro then click OK.

Right click the button and select Edit Text. Enter the caption that you want the button to display. Select any cell to finish.