Calculate row/column number in reference formula
Hello,
I have the below formula in a cell: =Sheet1!A19 Now instead of 19 I want to calculate the value 19 like (current row number -1) but obviously putting the formula as =Sheet1!A(Row()-1) doesn't work. How can I set it as a calculated value? Thanks! |
Calculate row/column number in reference formula
mirin wrote:
Hello, I have the below formula in a cell: =Sheet1!A19 Now instead of 19 I want to calculate the value 19 like (current row number -1) but obviously putting the formula as =Sheet1!A(Row()-1) doesn't work. How can I set it as a calculated value? Thanks! =INDIRECT("Sheet1!A"&ROW()-1)) |
Calculate row/column number in reference formula
=INDIRECT("Sheet1!A" & ROW()-1)
"mirin" wrote: Hello, I have the below formula in a cell: =Sheet1!A19 Now instead of 19 I want to calculate the value 19 like (current row number -1) but obviously putting the formula as =Sheet1!A(Row()-1) doesn't work. How can I set it as a calculated value? Thanks! . |
All times are GMT +1. The time now is 04:36 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com