How to refer merged cell in Excel?
Is it possible to refer value in related cell, taking merge status into
account? I.e. if referred cell is falling into some merged cell, then take
value from it.
Direct method does not work:
As you see, referred value changes. For example, cell B3 refers cell A3
and gets zero, despite the fact that this cell contains 2013. Only A2 is
treated containing 2013 by reference.
No comments:
Post a Comment