R
Ryan H
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!
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!