aggregate data

  1. P

    Updating existing data from new worksheet by replacing only corresponding values

    Dear All, I have a Master sheet where I use to show the overall project progress. I get updates from my Contractors on a weekly basis. Both the sheets are of same formats and fields. The master sheet acts as a repository of all data (Numbers and dates). I want the Contractor sheets to feed the...
  2. S

    Help with Pivot Tables

    I have spreadsheet with the performance data of 50 search engine search terms across multiple ad campaigns in Google and Bing. For each of the data columns below, I would like to create a formula I would use to aggregate the data in a pivot table: 1) Impressions 2) Clicks 3) Click-Through Rate...
  3. D

    Simplify and optimize a complex series of vlookups

    Hi all, I have a bit of an issue and thought this might be a good place to get some ideas. I have a set of data with client ID going vertically down and then horizontally I have the date the client moved to a certain status. I want to know at any given time how many clients are in each...
  4. M

    #DIV/0 error!

    hi, I don't know how to explain, but I'll try :) I have 5 worksheets (each of them being 8 columns x 52 rows... if this matters) with the first worksheet aggregating (totaling, averaging, etc.) data from the other 4. Now, the secondary worksheets are fine and I can fiddle with them as I wish...

Some videos you may like

This Week's Hot Topics