Kongta
asked on
calculation problem due to ongoing field
I do calculate in a fix field the yield of a data-set as follow:
=Kurs!B593/Kurs!B2-1
which works perfect. But I have to change every day the field-link which I would like to avoid and tried therefore
=Kurs!B2000/Kurs!B2-1
which doesn't work as B2000 is not yet filled with a value. I tried this because on diagram, this works fine. Any idea what's the best way to get yield without manualy changing the formula?
thx
Kongta
=Kurs!B593/Kurs!B2-1
which works perfect. But I have to change every day the field-link which I would like to avoid and tried therefore
=Kurs!B2000/Kurs!B2-1
which doesn't work as B2000 is not yet filled with a value. I tried this because on diagram, this works fine. Any idea what's the best way to get yield without manualy changing the formula?
thx
Kongta
ASKER
You can use the formula
=INDIRECT(ADDRESS(MATCH(99 ^99,$B1:$B $65536),2) )/B1-1
See attached
Dave
test-r1.xlsx
=INDIRECT(ADDRESS(MATCH(99
See attached
Dave
test-r1.xlsx
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
bingo, cool, have many thx
-RK