one way:
=INDEX(2:2,COUNTA(2:2))/INDEX(2:2,COUNTA(2:2)-1) - 1
Formatted as a percentage
In article ,
"Lazia" wrote:
Hi All, Please help me by creating a simple formula to findout the percentage
differences of "current month" - "last month" automatically whenever the data
is updated.
Grade Year Jan Feb Mar Apr May
1 2005 2555 3488 2213 3239
Thanks,
Lazia
|