Page Comparison

Move the “Price last year” column to the right of the “Sales price (Original currency)” column

Perform data cleaning, if necessary (see note above)

Insert a new column to the right of “Price last year” and name it “Price Increases”

Insert the following formula =H4/I4-1 in cell J4

1. where column H is “Sales price (Original Currency)”

2. where column I is “Price last year”

3. where column J is “Price Increases”

Drag the formula in J4 down tol to fill the column

Select the “Price Increases” column and apply the Percentage format to it