Prev: why does a sumproduct formula return a #div/0!
Next: existing connections
From: T. Valko on 14 Sep 2009 17:37
Why not simply:

A10: =INDEX(B1:B2,1+($A1>$A2))
A11: =INDEX(B1:B2,1+($A1<=$A2))

Copied across to B10:B11

:-)

--
Biff
Microsoft Excel MVP


"Bernd P" <bplumhoff(a)gmail.com> wrote in message
news:4013505f-08e2-450b-8044-414fbf105a08(a)z34g2000vbl.googlegroups.com...
> Hello,
>
> If I understand you correctly, select A10:B10 and array-enter
> =INDEX(B1:B2,1+(A1>A2)):INDEX(C1:C2,1+(A1>A2))
>
> Then array-enter into A11:B11:
> =INDEX(B1:B2,1+(A1<=A2)):INDEX(C1:C2,1+(A1<=A2))
>
> Regards,
> Bernd


From: Bernd P on 15 Sep 2009 01:49
Hello Biff,

> Why not simply:
>
> A10: =INDEX(B1:B2,1+($A1>$A2))
> A11: =INDEX(B1:B2,1+($A1<=$A2))
>
> Copied across to B10:B11
>
> :-)
>

....Yeah, that'll work :-)

Regards,
Bernd

First  |  Prev  | 
Pages: 1 2
Prev: why does a sumproduct formula return a #div/0!
Next: existing connections