admin管理员组

文章数量:1295946

I am using OpenOffice Calc. I have a text which is address range, indirectly used for my calculations. My text is "C5:K5". It may vary at times.

I use ROW("C5:K5") and COLUMN("C5:K5") functions to get row as 5 and column as 3. So, these are values of "C5". How can I get row and column of "K5" from "C5:K5"? That is the second part of the range

I tried COLUMN(indirect(text)), but it gives from the first part only.

本文标签： spreadsheetIs there a formula to get row and column of range end in openoffice calcStack Overflow

版权声明：本文标题：spreadsheet - Is there a formula to get row and column of range end in openoffice calc? - Stack Overflow 内容由网友自发贡献，该文观点仅代表作者本人， 转载请联系作者并注明出处：http://www.betaflare.com/web/1741619143a2388706.html， 本站仅提供信息存储空间服务，不拥有所有权，不承担相关法律责任。如发现本站有涉嫌抄袭侵权/违法违规的内容，一经查实，本站将立刻删除。