Need a formula that changes each month to Calculate an Increase or Decrease from Previous month

[DWL33]

here is my Excel...

column N is where the Increase or Decrease is calculated[formula; =IFERROR(($I3-$H3)/$I3,"")]
Every month I have to manually adjust this with the addition of the next month data.
I would like not to have to change this every month manually.

Please HELP!! DWL33

 

[Noxqss38242]

Can you add rows as part of the solution? If so, I have a work around that works.
Once in place, you never have to really fool with it.
Also, when unhidden, you can show whomever the ups and downs for each month as well.

Deals with conditional formatting for your arrows, formula to pull from the cell with data furthest right, etc...

Ignore formulas

maintacc-NEW.xlsx
	C	D	E	F	G	H	I	J	K	L	M	N	O
10
11												Increase
12												Decrease
13												Order Description
14
15
16
17
18
19					Jan	Feb	Mar	Apr	May
20			cardio		12	5	8	9	15
21	added row
22			cardov		5	9	3	7	7
23	added row
24			cardioex		20	17	26	13	30
25	added row
26			funny times		220	215	236	277	297
27	added row
28			not funny		10	5	9	2	6
29
30
31
32
33
Sheet1

Cell Formulas
Range	Formula
N14	N14	=LOOKUP(2,1/(H21:K21<>""),H21:K21)
H29:K29,H27:K27,H25:K25,H23:K23,H21:O21	H21	=IF(H20="","",(H20-G20))

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
H29:K29	Other Type	Icon set		NO
H29:K29	Other Type	Icon set		NO
H29:K29	Other Type	Icon set		NO
H27:K27	Other Type	Icon set		NO
H27:K27	Other Type	Icon set		NO
H27:K27	Other Type	Icon set		NO
H25:K25	Other Type	Icon set		NO
H25:K25	Other Type	Icon set		NO
H25:K25	Other Type	Icon set		NO
H23:K23	Other Type	Icon set		NO
H23:K23	Other Type	Icon set		NO
H23:K23	Other Type	Icon set		NO
N14	Other Type	Icon set		NO
N14	Other Type	Icon set		NO
H21:P21	Other Type	Icon set		NO
H21:P21	Other Type	Icon set		NO
H21:P21	Other Type	Icon set		NO

 

[DWL33]

I forgot to mention the monthly data is pulled from a Pivot Table from another WS in the same WB for each row of Order Descriptions.
here is the formula cell i3 of my Excel...

" =IFERROR(GETPIVOTDATA("Order Description",pvtWorkSheet!$H$10,"Facility",$A$13,"Order Description",$A15,"Month",I$14),"")

Not sure if this matters...DWL33