Creating a Function
Harald - thats perfect
can you explain to me what the function below does - very grateful,
I understand each individual function but not working together
SUMPRODUCT(MAX(ROW(A1:A12)*(A1:A120)))
"Harald Staff" wrote:
Hi
Try this little thing in A13:
=TEXT(DATE(1,SUMPRODUCT(MAX(ROW(A1:A12)*(A1:A120) )),1),"MMM")
HTH. Best wishes Harald
"teresa" skrev i melding
...
If A1 0 AND SUM(A2:A12) = 0 then A13 = Jan
If A2 0 AND SUM(A3:A12) = 0 then A13 = Feb
If A3 0 AND SUM(A4:A12) = 0 then A13 = March
etc.etc.
Rather than just using nested Ifs which is cumbersome I am trying:
Function Month(Integer)
Select Case Integer
Case a10,sum(a2:a12)=0
Month = "Jan"
etc....
help is much appreciated - thanks
|