Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I have a 1-dimensional array whose members are single letter values, i.e.
V(1) = "A" V(2) = "B" V(3) = "C" V(4) = "A" V(5) = "B" V(6) = "A" V(7) = "B" V(8) = "A" V(9) = "B" V(10) = "C" I'd like to create a new array that is a filtered version of the array above, where all duplicates are removed so that each member of the new array is unique and not repeated, i.e. A(1) = "A" A(2) = "B" A(3) = "C" Any ideas on the best method? I can possibly visualize doing this with some loops, but I'm having trouble getting my head around it. Any ideas welcome. Thanks! -gk- ================================================== ====================== "The creative act is not the province of remote oracles or rarefied geniuses but a transparent process that is open to everyone." -Greg Kot in Wilco Learning How To Die- |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Pivot Table Report Filter - "OR" instead of "AND" Multiple Filters | Excel Discussion (Misc queries) | |||
Excel - Golf - how to display "-2" as "2 Under" or "4"as "+4" or "4 Over" in a calculation cell | Excel Discussion (Misc queries) | |||
"Type mismatch" when I try to fill an Array variable with "+" | Excel Discussion (Misc queries) | |||
How do I use "offset" function in "array formula"? | Excel Discussion (Misc queries) | |||
If changed array formula reduce ""\""\""\ - signs to #Missing, will it make ... | Excel Programming |