Wow, very cool WenQQ3. Thanks for this help.

So let me clarify:

1) a "1" is actually better than a "10" because we're talking about rankings on Google. So, #1 is the top spot! (i say this because your 'aggregate %' is showing a negative on the 2nd day (and should be positive because all rankings on row 6 went up)

2) so on the first new column ("F") i want to know how much all my rankings on an aggregate level went up or down (percentage) verses the day before.

3) the second column ("G") should show aggregate % increase verses the very first day (row 5).

thank you so much for helping.