how to create comparison sales yoy

George Perea 0 Reputation points
2026-07-28T22:48:42.2166667+00:00

Compile a customer list of sales for MGP caliper covers to identify declining or diminished sales in a one year period

Microsoft 365 and Office | Excel | For business | Windows

1 answer

Sort by: Newest
Most helpful Newest Oldest
  1. William Son 0 Reputation points
    2026-11-11T16:35:12.0466667+00:00

    Put last year's sales in one column and this year's sales in the next column, one row per customer. Then use this formula in the next column to get the change:=(C2-B2)/B2

    Here B2 is last year's sales and C2 is this year's sales. Format the cell as a percentage.

    For example, if a customer had sales of 250 last year and 200 this year, the formula gives (200-250)/250, which is -20%. That means sales for that customer fell by 20% in one year. Sort the percentage column from smallest to largest, and the customers with the biggest drops will be at the top.

    Was this answer helpful?

    0 comments

Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.