Re: Syntax for a relative formula
Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance
Sorry, I don't understand what you mean. How would a formula like
= iif (row() and col() = row() and col(), offset(......
do anything, you are still stuck with the offset() requiring a cell
reference, which is lacking.
Ian Murphy
.
Relevant Pages
- RE: Wild Card Vlookups
... 'Cell Formula using the OFFSET worksheet formula with multiple criteria to ... 'Returns a reference to a range that is a specified number of rows and columns ...
(microsoft.public.excel.misc) - Re: Nesting Address function in Offset without Quotes???
... The INDIRECT function will convert your text string "A1" into a cell ... is a cell reference. ... Address does the trick except that the offset function ... quotes). ...
(microsoft.public.excel.worksheet.functions) - RE: Using an offset formula for the reference in a relative refere
... Sheet1!A1:C4 and A1 is linked to a cell in Sheet1!A1:C4 ... I will need to figure out how to extract the variable cell reference data ... Sheet 2 to populate the row and column info in the INDEX/MATCH ... I can embed an OFFSET formula in the ...
(microsoft.public.excel.worksheet.functions) - RE: Using an offset formula for the reference in a relative refere
... I will need to figure out how to extract the variable cell reference data ... from cell A1, Sheet 2 to populate the row and column info in the INDEX/MATCH ... since the number of rows for the offset will be ...
(microsoft.public.excel.worksheet.functions) - Re: Create cell formula from a relative position
... reference - just as if you had typed it). ... You can try to use your code to figure out the proper cell addresses to ... > but it only calculates the absolute position of C1*H1 ... >> And, in general, this is the way it works: Offset gives a range the same ...
(microsoft.public.excel.programming) |
|
