hello Mentors,

could somebody please suggest how would I get the % of increasing or decreasing in attached sheet. In Tab 1 my data shows dept, % and year. for an example - Dept. Recs - May 2021 number is 115 (in %) and for the same dept number is 120 (in %)

what formula should I use to show increasing or decreasing number for the same.

please help.

Maddy

Attached Files

increase-decrease.xlsx (8.8 KB, 10 views)