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! |
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) |