Question about Sumproduct Function
Posted on 2013-12-27
The function below attempts to use Trim function on a range name so that I can indent the referenced cell (the range has no indents). It fails as soon as I add a space to the name in A11.
In another case I tried to extract the year from a date by using the Year function in a similar way to what you see below. That also failed and I had to create a new column in the data.
I admit to being a Lotus 1-2-3 user when I can be wherein all of this is quite simple and elegant.
Thanks for any help and have a happy new year