I am facing problem while referencing all cell of merged cell as a individual cell, because its take first col first row of merged cell as reference cell in any formula.
Ex. in Attachment example case i have some data in column A, I have formula in Column B as RC[-1], and result showing as column B, but i want output as column C.
Bookmarks