| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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! |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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)) |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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! . |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Reference a number from a different column in a formula | Excel Worksheet Functions | |||
| Calculate a number for 80% of column | Excel Worksheet Functions | |||
| How to calculate and display the number of values in a column | Excel Discussion (Misc queries) | |||
| How do I Calculate Percentages for each number in a column? | Excel Discussion (Misc queries) | |||
| Calculate number of days in a column of dates | Excel Discussion (Misc queries) | |||
Linear Mode
