function select – 2 catergories

Question

2.78K viewsAugust 11, 2014Formulas and Functions

0

Hi.

I have a problem with the function select attached.

Trying to get E3 in Matrix 2 = 11

Please help .

0

thank you

score 1 · Answer 1 · 2014-08-11T11:33:51+00:00

Hi,

Try to use this formula:

E3 = select( Matrix1::B1, @Matrix1::Year:Month, E1 & ":" & E2 )