Combine Two Arrays Into One. Tough.
I have a function that alphabetizes an array of text:
=INDEX($A$1:$A$10,MATCH(ROW(A1),COUNTIF($A$1:$A$10 ,"<="&$A$1:$A$10),))
CSE-entered
I also have a function that eliminates dupes:
=IF(ISERR(SMALL(IF(MATCH($A$10:$A$16,$A$10:$A$16,0 )=ROW(INDIRECT("1:"&ROWS($A$10:$A$16))),MATCH($A$1 0:$A$16,$A$10:$A$16,0)),ROWS($10:10))),"",INDEX($A $10:$A$16,SMALL(IF(MATCH($A$10:$A$16,$A$10:$A$16,0 )=ROW(INDIRECT("1:"&ROWS($A$10:$A$16))),MATCH($A$1 0:$A$16,$A$10:$A$16,0)),ROWS($10:10))))
CSE-entered
Now, Im wondering if I can combine the two. That will take some hack work.
Also, Im wondering how much this will slow down the workbook. There are
about 8-9 sheets in there and an array formula like this will probably make
the thing crawl, right. Anyway, my question is how do I combine there two
arrays?
Thanks,
Ryan--
--
Ryan---
If this information was helpful, please indicate this by clicking ''Yes''.
|