The enclosed worksheet shows my attempts to create a worthwhile dashboard.
The range marked in yellow range(Q30:AD32) shows the summary I am stuck on. This changes every month when the next column is calculated.
What I want to do is to put in R30;R32 the number that is in the corresponding row in the range where the next result will be -100.
I can do this in vba but it will be much easier to deal with as a formula in R30;R32, and I have had no success in devising one.
Can anybody help please?
John
Bookmarks