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
Bookmarks