Need help comparing data from different URL's.

[marketingninja]

Let me start off by saying, that I'm an Excel Dummie. Furthermore,
don't know if this is possible...

Basically, i need to compare the keywords on 5 websites based o
diferent criteria, like density, prominence, etc. In all, about 1
different criteria.

Here's where it gets tricky... I need to ONLY compare the keywords tha
ALL 5 websites have in common. (It might be great to filter by number o
websites, but I don't want to get too complicated)

So basically I take 5 websites, paste all of their keywords in t
excel, sort by website, and compare common keywords based on about 1
factors.

Hopefully this makes sense. I'd appreciate all responses. (I looked a
a Pivot Table video on YouTube, but it didn't seem like what I neede
unless I missed something).

Let me know if this is possible and what it would take.

Thanks,
De

 

[Don Guillett]

It may??? be possible to do this all with one mouse click. If desired, send
me your workbook and details along with the url info needed to take a look.
Copy this snippet so I will know from whence it came.

 

[marketingninja]

If you can do this, you'll be a life saver! I posted to 3 differen
forums and you're the only one who responded!

Thanks a lot! I will email the info to you.

Regards,
Dee