Power Tools v1.16

Compare sheets cell by cell for differences

Yet another comparison tool you may think… But think twice ;D This add-on doesn't just look for duplicates or uniques. It compares cells in each row between multiple Google sheets and marks all differences.

There are 2 ways to track those differences:

• have them highlighted and even described in a status column in each sheet.
• have everything grouped in one comparison report in another spreadsheet for the whole picture in one place:
  

Merge multiple lookup sheets in one go

Merge Sheets underwent some major changes as well. First and foremost, it finally lets you merge more than 2 sheets at a time:

You add as many lookup sheets as you need on the 2nd step, and the add-on takes the required data from them one by one to your main sheet:

I'm not going to go over all the details and other new features for Merge Sheets here since I announced them earlier in this release notes, but here are a few highlights:

1. Insert additional matching rows. For when you also want to pull those extra rows that belong to the same key value:
   
2. Pull notes along with their values from lookup sheets:
   
3. Add sheets from more places of your Drive:
   

Sum or count ALL colored cells

Function by Color now knows how to sum or count not just one but all colors in the range of interest. It builds one formula that returns the names of all colors with their calculated results:

The settings are almost the same and you'll find them on the additional tab — All colors:

Split sheet by any number of rows

The upgrade didn't bypass Split Sheet. It features a new way to split your table: by a certain number of rows:

You'll be able to fine-tune the number in 2 ways:

• enter the exact number to split rows by, e.g. by every 10 rows
• or specify the groups of rows you'd like to see in separate sheets, e.g. 1-10, 11-50, 51-500

Sort by color

Our Power Tools has acquired its own Sort by Color. And it works unlike the Google Sheets built-in tool, so I recommend you check it out anyway:

Our add-on gathers all colors together and sorts them in the order you specify directly in the add-on:

The built-in Google Sheets tool gathers only the rows of the selected color at the beginning of your table:

So based on your task, you may need one tool or another. Another is in our Power Tools ;) These instructions will help you get started.