Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Is there a way to load data strings (with some duplicates) into a container
and then use some form of .Exists and .Remove (i.e. not an array) to redefine the container? Note I need the duplicates for calclations purposes. I have a list of strings. I load them into a container. There are duplicate strings. I need the duplicates as I am calculating the frequency of their occurences. I then check the entire list for a sub list of strings and remove these strings. Becasue I am using duplicate strings I cannot use a collection or a dictionary as they cannot take duplicate keys. Therefore I am using an array. However when it comes time to removing the stings (rows) I don't have the luxury of using .Exist booleans as I can with a dictionary object. I have to loop through the entire array to see if the sting exists AND THEN I have find a way to get rid of all my empty rows in the array. Probably the best way to do this is to transfer all nonempty data from first arraty into second array and then back to first arrray. Bit of pain Any ideas? Thanks EM |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
sorting/no duplicate scripting dictionary in Excel VBA | Excel Programming | |||
Enumerating PivotItems collection fails to display duplicate values | Excel Programming | |||
Collection VS Scripting.Dictionary | Excel Programming | |||
Limitation of collection and dictionary datatype | Excel Programming | |||
Linking MS dictionary as data into Excel | Excel Programming |