SEO Tip – Identify New Data Between 2 Excel Sheets
Paul our new Excel guru has shown me a nifty little trick that im sure you’ll find interesting.
I was discussing how each month Open Site Explorer outputted new data and it was hard to integrate this into an existing (previous months) worksheet without potentially overwriting the work already done.
He rolled his eyes and said “easy… give me a minute” and then dropped this on me:
=VLOOKUP(A1,Sheet1!A:D,1,0)
What it does is compare the (old) data in a tab called Sheet1 with the new data in Sheet2 using the first column (URL) as the measurement. Then all entries that are new will be labelled NA and can be integrated into the (old) work sheet.
Awesome stuff. Thanks Paul
Awesome! Quite a nifty trick to know. Thanks for sharing – This will most defintely come in use…
Keep up the Awesome posts Mark.
Great info – very necessary for freelancers.
One addition I’d make is realizing and speaking up with things go beyond scope of the original contract. I recently had…
That’s really awesome stuff Mark. I would say your Excel guru is awesome in his skills ! Segregating the data by this way is really easy and interesting! Thanks for the Excel formula!