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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

compacting UPPER/LOWER & column reference 1
How to convert whole array to upper 1
Workaround for UPPER(F31:F10000) 1
Workaround for LOWER(A1:A100) 4
How to check a condition and write another cell 0
Calc Speed & Formula simplification 2
Averaging not Summing 4

Top