ruiseixas
New Member
- Joined
- Jul 3, 2005
- Messages
- 6
Hi,
I am having difficulty on this one:
Suppose you have these 2 arrays, each one from one sheet:
{1, 3, 5} and {2, 4, 6}
and from the both arrays I want to extract the 1st or 2nd lowest elements into two different cells.
Like this:
Cell1 = 1
Cell2 = 2
Nothing complicated if some how we link the two arrays in to this one:
{1, 3, 5, 2, 4, 6}
Solution:
Cell1 -> {=SMALL ({1, 3, 5, 2, 4, 6}, 1)
Cell2 -> {=SMALL ({1, 3, 5, 2, 4, 6}, 2)
The plus sign (+) don't work and gives {3, 7, 11}, and that is not what I need.
Any one out there can figure out a way (array formulas) to make the following without macros?
LINK ({1, 3, 5}, {2, 4, 6}) = {1, 3, 5, 2, 4, 6}
Thanks folks.
I am having difficulty on this one:
Suppose you have these 2 arrays, each one from one sheet:
{1, 3, 5} and {2, 4, 6}
and from the both arrays I want to extract the 1st or 2nd lowest elements into two different cells.
Like this:
Cell1 = 1
Cell2 = 2
Nothing complicated if some how we link the two arrays in to this one:
{1, 3, 5, 2, 4, 6}
Solution:
Cell1 -> {=SMALL ({1, 3, 5, 2, 4, 6}, 1)
Cell2 -> {=SMALL ({1, 3, 5, 2, 4, 6}, 2)
The plus sign (+) don't work and gives {3, 7, 11}, and that is not what I need.
Any one out there can figure out a way (array formulas) to make the following without macros?
LINK ({1, 3, 5}, {2, 4, 6}) = {1, 3, 5, 2, 4, 6}
Thanks folks.