Repost -calculate % change for each phrase.
 

Hi,

I apologize for the confusion of my last post.
Your assistance will be greatly, greatly appreciated.

Attached is a sample of the data. The workbook has 3 data sets; one for each
worksheet. The data will be consolidated in one Access table. The objective
is to analyze trends on searches and results of keyword phrases by:

* calculating % change for each phrase and
* graphing the top 20 increases and decreases in terms of percentage change
over time.

The data comes from a web tool that track keywords searches from google and
other search engines.

I am actually thinking about a pivot report as the solution.


Thanks
Gwen