large

M

mc-iii

My fault not a good explanation:

I have two sheet, one is for the actual month and another last month.

The estructure of both sheet is

Sheet_1 - Month N
Code Price
A 10
X 9
Z 6
B 3
F 2
W 5
R 11

Sheet_2 - Month N-1
Code Price
H 11
M 9
R 10
X 2
A 4
Z 2


Note that the two sheet didn´t have the same number of rows, and i hav
code in this month that no exist last month

I want to know with a formula (large) which is the code with th
biggest increase of price, and the second one and the 3º.

Result of the formula:
1. Code X - Increase: 350%
2. Code Z - Increase: 200%
3. Code A - Increase: 150%




Thank
 
Top