Google Spreadsheet Comparing Sheets Of Data and Returning only Unique Values

Question:

( by Lewis Sellers )

Hi All,

We've got a Google spreadsheet file that has 4 sheets within it. The sheets should be compared using Column A (URL) only, then using all the rest of the data to try and fill in gaps that may appear from each one.

What I want to do is create a new sheet that compares all the other 4 sheets and pulls in Unique values only.

For example (hopefully this makes sense... It's only a very small

Sheet A:

Sheet B:

Sheet C:

Sheet D:

Sheet E (New Sheet):

So in theory, the new Sheet E will look through all of the data and compare the data from each of the sheets. I will make sure that all the headings are the same across the pages. What we want to avoid is lots of duplicates so that we have one clear sheet to work with.

There's lots of additional data on the sheets, so we just need to aggregate it into one clean and easy to read list.

Any help would be much appreciated.

Thanks!

Lewis

Solution:

You will need to install script VMerge from Script Gallery.
Go to menu "Tools" > "Script gallery" and then search for "vmerge" and then install it.

After you have installed the script, put the following formula in Cell A2:

=unique(query(vmerge('Sheet A'!A2:C;'Sheet B'!A2:C;'Sheet C'!A2:C;'Sheet D'!A2:C);"select * where Col2<>'' ";0))

I hope the above solution will help you, and if you need more help then please do comment below on this blog itself, I will try to help you out.

I also take up private and confidential projects:

http://igoogledrive.blogspot.com/p/paid-projects.html

If this blog post was helpful to you, and if you think you want to help me too and make my this blog survive then please donate here: http://igoogledrive.blogspot.com/2012/09/donate.html 

Thanks,

Kishan.

iGoogleDrive