Forum Discussion
Excel Dashboard: Formula Help with avg over weeks
Hello!
I was wondering if anyone has suggestions on a simple but effective way to track our $ increases week over week.
So for example week 1 we might have an avg sale of $11.00, next week $11.02. What formula could I use to show the percent increase ONLY if we want to look at the most recent two entries.
Thank you!
Let's say your data are in B4:Z4.
The increase/decrease from the next-to-last value to the last value is
=LET(last2, TAKE(FILTER(B4:Z4, B4:Z4<>""), , -2), INDEX(last2, 2)/INDEX(last2, 1)-1)
Format the cell with this formula as a percentage.
This can be filled down if required.
Let's say your data are in B4:Z4.
The increase/decrease from the next-to-last value to the last value is
=LET(last2, TAKE(FILTER(B4:Z4, B4:Z4<>""), , -2), INDEX(last2, 2)/INDEX(last2, 1)-1)
Format the cell with this formula as a percentage.
This can be filled down if required.
- Thank you!!!
