G
Guest
Guest
Hi,
I have a function that returns an array of unique items in a given range
eg unique = FindUnique(A1:A200)
Which is fine and dandy.. the problem is, I want an array of the non-unique items. Since Excel has union, intersect funcs.
1. Is there a function that does subtract??
ie something like .. non-unique = Application.Subtract(A1:A200, FindUnique(A1:A200)??
Got the function from the web, and I have no programming experience to modify it.
2. How do you populate items from an array into cells, got this little code here.. seems a bit slow
for i = 0 to UBound(myArray)
Range("A1").Offset(i, 0).Value = myArray(i)
next i
Thanks!
I have a function that returns an array of unique items in a given range
eg unique = FindUnique(A1:A200)
Which is fine and dandy.. the problem is, I want an array of the non-unique items. Since Excel has union, intersect funcs.
1. Is there a function that does subtract??
ie something like .. non-unique = Application.Subtract(A1:A200, FindUnique(A1:A200)??
Got the function from the web, and I have no programming experience to modify it.
2. How do you populate items from an array into cells, got this little code here.. seems a bit slow
for i = 0 to UBound(myArray)
Range("A1").Offset(i, 0).Value = myArray(i)
next i
Thanks!