Defined Arrays

[Zeesh]

I have been banging my head on the table trying to solve this for the last two days. I would be absolutely grateful if someone could help me here.

The actual piece of work that I am working on is too complicated to post here. But I'll make things nice and simple just for the cause.

I defined an array called "Test_1" containing digits {1,2,3,4,5}
I then defined another array called "Test_2" containing a formula =MIN(Test_1,3)

If I paste "Test_2" on the worksheet with =INDEX(Test_2,1) This gives me value 1
But if I paste it with =INDEX(Test_2,2) up to index of 5, it gives me #REF error.

The reason is that "Test_2" doesn't become an array and all it does is picks the min value from the entire "Test_1" (which is 1) and compares it with 3 and returns 1. However, what I would like "Test_2" to do is compare every single value in "Test_1" against the number 3 and record it as an array.

Does anyone know how to make this possible? How do I make "Test_2" store {1,2,3,3,3} values?

Thanks

[Kaper]

have you tried simple
Test_2

Please Login or Register  to view this content.

[Zeesh]

Thanks Kaper.

Your suggestion is working for the example that I gave. But the actual code that I am working on is way more complicated. However, your suggestion has helped me in figuring a way out of my problem so thanks. :D

[Kaper]

Glad to hear that.
If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.
Thanks.