List of Unique Values
 

I have a table in excel in which I have several different scenarios an
each scenario involves a series of control points (some scenario
repeat control points, some don't.) I was curious if there is a way t
use VBA to generate a list of all the unique control points

--
cmk1
-----------------------------------------------------------------------
cmk18's Profile: http://www.excelforum.com/member.php...nfo&userid=604
View this thread: http://www.excelforum.com/showthread.php?threadid=38157

List of Unique Values
 

You don't need VBA, you can do it with DataFilterAdvanced Filter and check
the Unique Records box.

--
HTH

Bob Phillips

"cmk18" wrote in
message ...

I have a table in excel in which I have several different scenarios and
each scenario involves a series of control points (some scenarios
repeat control points, some don't.) I was curious if there is a way to
use VBA to generate a list of all the unique control points.


--
cmk18
------------------------------------------------------------------------
cmk18's Profile:
http://www.excelforum.com/member.php...fo&userid=6047
View this thread: http://www.excelforum.com/showthread...hreadid=381572

List of Unique Values
 

That produces a static list though, I need somethign that changes as yo
add or delete nodes. Is there someway to use this functionality in VB
(maybe the in the Worksheet_Activate sub routine) to make the lis
dynamic

--
cmk1
-----------------------------------------------------------------------
cmk18's Profile: http://www.excelforum.com/member.php...nfo&userid=604
View this thread: http://www.excelforum.com/showthread.php?threadid=38157

List of Unique Values
 

You could use filter in a worksheet change event to generate a unique list.

--
HTH

Bob Phillips

"cmk18" wrote in
message ...

That produces a static list though, I need somethign that changes as you
add or delete nodes. Is there someway to use this functionality in VBA
(maybe the in the Worksheet_Activate sub routine) to make the list
dynamic?


--
cmk18
------------------------------------------------------------------------
cmk18's Profile:
http://www.excelforum.com/member.php...fo&userid=6047
View this thread: http://www.excelforum.com/showthread...hreadid=381572