On May 9, 3:08 pm, Harlan Grove wrote:
wrote...
...

When I added more cells in the Define Name area it gives me a VALUE
error. Here what I got:

Arrays =EVALUATE("{"""&SUBSTITUTE(Temp,",",""",""")&"""}" )

Temp =Temp1&","&Temp2&","&Temp3
...
It works for Temp1 & Temp2 but if I add Temp3 it gives me that error.
What do you think the problem is?

I should have foreseen this. EVALUATE's argument can only be so long,
and it appears you've bumped into that limitation. At this point I
believe you need to abandon any hope of elegance and use a LOT of cell
formulas. Basically, you'd need to split out the contents of
<whatever!D2:D300 into separate cells.

Thank you Harlan I will split them into into multiple columns. To try
to get the uniques of it.

Once again Thank You!