How to convert whole array to upper

P

Pantryman

Hi Jason,

D20 =

=IF(ISBLANK(C20),"",IF(ISERROR(OFFSET(U2
MATCH(C20,U3:U17,0),-2)),"DEFINE",OFFSET(U2,MATCH(C20,U3:U17,0),-2)))

But if D20 is found in F as an exact matching case, it is counted.

Otherwise, it's not.

=SUMPRODUCT(--(A31:A10000>TODAY()-90),--(F31:F10000=D20),M31:M10000)

Am I missing something
 
Top