aggregate data

ello any help or direction to recourses or YouTube will be appreciated to help me in resolving below I need to aggregate multiple xls files with specific name from multiple folders and subfolder into one file. I receive multiple reports every day that are saved with in folder with Date in the...

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...

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...

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...

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...