Need help with trend arrow, current month to previous month

[Kulraj Singh]

This is the data I have I want to use up and down arrows to indicate trend from previous month to current month. Sample data is attached.

 

[Hui]

O3: =IFERROR(IF(OFFSET($A3,,COUNTIF($B$17:$N$17,">0"))>OFFSET($A3,,COUNTIF($B$17:$N$17,">0")-1),"↑","↓"),"")
Copy down

This uses the data in the Total row to determine the last Month with data and hence the previous month

 

[NARAYANK991]

Hi ,

Another option , which is available only if you have Excel 2010 or later versions , is to use Sparklines.

See the attached file.

Narayan