Complex array formula
Dear all,
One part of my database contains 5 columns with values >=0. I come up with a solution in order to get the address of cells which has values greater than 0, within each row of my database. This addresses will then be used to extract values of other cells, relatively positioned within this cells.
I have used arrays (as I try to improve my knowledge within this feature) and after getting the result, I have tried to simplify the formula, but an error occurred which I cann't explain to myself.
Everything is in the attached file.
By the way, can you recommend some good books / articles / posts etc. about advanced arrays?
Andrei
|