I have a work spreadsheet which shows absenteeism by month. I want to see a single Icon (Arrow) to show the primary trend across the most recent 12 months of data; for example, if the absenteeism trend line is declining - a single downward arrow. if the absenteeism over 12 months is increasing - a single upward arrow; and, if the absenteeism is consistent (for example 1 day each month) - a horizontal arrow.
I know how to use sparklines, but I need a formula to vary between the three options/icons in a single column due to large number of staff represented. The challenge is that my workplace has restricted use of macros and Visual Basic.
I'd be grateful for any assistance. I've attached a simple file to simply reflect five fictitious staff. Column N is where I'd like the formula to produce the arrow corresponding with the trendline (Note: I have simply inserted Icons as I'd like them to appear).
Thank you in advance,
Chris
I know how to use sparklines, but I need a formula to vary between the three options/icons in a single column due to large number of staff represented. The challenge is that my workplace has restricted use of macros and Visual Basic.
I'd be grateful for any assistance. I've attached a simple file to simply reflect five fictitious staff. Column N is where I'd like the formula to produce the arrow corresponding with the trendline (Note: I have simply inserted Icons as I'd like them to appear).
Thank you in advance,
Chris