Forum Discussion
Solved
Automate Calculating Data
Hi, I'm building a spreadsheet that will track monthly metrics and want to automatically calculate changes in two areas: Percentage change since the initial (baseline) metric Percentage change...
In N2:
=INDEX(G2:M2,COUNT(G2:M2))/G2-1
In O2:
=INDEX(G2:M2,COUNT(G2:M2))/INDEX(G2:M2,COUNT(G2:M2)-1)-1
Format both cells as a percentage.
The formulas can be filled down.
In N2:
=INDEX(G2:M2,LARGE(IF(G2:M2<>"",COLUMN(G2:M2)-COLUMN(G2)+1),1))/G2-1
In O2:
=IFERROR(INDEX(G2:M2,LARGE(IF(G2:M2<>"",COLUMN(G2:M2)-COLUMN(G2)+1),1))/INDEX(G2:M2,LARGE(IF(G2:M2<>"",COLUMN(G2:M2)-COLUMN(G2)+1),2))-1,"")
