Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Build an Array of Different Values From Column
How can I build an array with non repeating values from a column? For
example, in Col. A I have this: Col. A 1 2 3 3 3 4 4 I want MyArray = Array(1,2,3,4). No duplications. Can I use the Split Function? MyArray = Split(MyRange, "", 1, ) ' this doesn't work, Err: Type Mismatch Thanks in Advance! -- Cheers, Ryan |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Build Array | Excel Programming | |||
build up an array using formulas | Excel Programming | |||
build up an array using formulas | Excel Discussion (Misc queries) | |||
build up an array using formulas | Excel Discussion (Misc queries) | |||
build array of columns | Excel Programming |