Showing name of row instead of excel cell name
Posted
by
Kare
on Super User
See other posts from Super User
or by Kare
Published on 2014-06-12T06:24:27Z
Indexed on
2014/06/12
9:28 UTC
Read the original article
Hit count: 217
I am having extremely long formulas over an extremely big sheet. At the moment I am tracking the formulas with the Formula Auditing
Tool. However, my idea would be to just replace for example in a formula like this:
=IF(AND(ROUND($GX19-SUM(0)/$M$12;2)<=0;$AK$7=1);0;$M$12*$M$22/$K$62
My idea would be to replace the excel cell names with the table row names they are in. Like:
=IF(AND(ROUND( "Income" -SUM(0)/ "Debt" ;2)<=0; "Percentage" =1);0; "Investment" * "Debt of house" / "Investment costs"
Is there any way to achive sth. like that in excel?
I appreciate your inputs!!!
© Super User or respective owner