| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formula (not adv. filter) to list unique values from list | Excel Worksheet Functions | |||
| Unique values within a list | Excel Discussion (Misc queries) | |||
| Identify & List unique values from a list using functions/formulas | Excel Worksheet Functions | |||
| Count unique values and create list based on these values | Excel Worksheet Functions | |||
| create list of unique values from a column with repeated values? | Excel Worksheet Functions | |||
![cmk18[_5_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Hybrid Mode
