Hi Ford,
Thanks for the additional tutorial...that was very helpful. Your explanations are far more succinct than the manual!
Admittedly, I'm having a little difficulty converting the sample formula (that worked perfectly in that sample sheet) to my actual spreadsheet. I'm fairly certain the problem is my unfamiliarity with how the OFFSET perimeters need to change based on a different size sheet (which your post addresses). I'm also referencing from Sheet 1 to Sheet 2 in my actual model which adds to the "clutter".
I'm going to do some further reading and poke at the formula a bit more, but may reach out with the actual sheet if I get stuck.
Regardless, I'll re-post my results and let you know how things turn out.
Thanks again for your help! David
Bookmarks