Excel User Group
Microsoft Excel blogs, forums, files. Read, ask questions, provide answers.

Browse Forum Posts by Tags

Showing related tags and posts for the Excel 2007 and 2010 forum. See all tags in the site
  • vlookup within vlookup

    I have two tables that i want to add together depending on values to produce a thrid summary table. Table one has the amount of days per month worked in each stage of the project. July August September Feasibility 144 168 160 Concept 70 176 160 Detail 160 24 0 Table two has all the rates of the different...
    Posted to Excel 2007 and 2010 (Forum) by nbothandford on Tue, Sep 9 2014
  • What VLOOKUP & SUM formula would I use ?

    Hi I have two worksheets. One listing all days against a individual contract e.g. Contracts Days 1234 1 1234 4 1234 2 1234 9 1235 1 1235 6 1235 0 1235 11 1236 7 1236 2 1236 20 1237 1 1237 7 1237 5 1237 5 and the other where I want to look this days total up for that contract e.g. Contract Total days...
    Posted to Excel 2007 and 2010 (Forum) by George3578 on Fri, Sep 5 2014
  • Need help populating rectangular matrix from row data

    I have an Excel spreadsheet table containing 1 row of data for each score submitted by each reviewer of each application. The number of applications is unlimited and, as reflected in the example table below, the number of reviewers submitting a score for each application is variable: Application Reviewer...
    Posted to Excel 2007 and 2010 (Forum) by Stendahl on Thu, Aug 28 2014
Page 1 of 1 (3 items)
Copyright Excel User Group and the relevant contributors, 2010. All Trade Marks acknowledged. This site is a peer-to-peer site and NOT affiliated in any way to Microsoft Corp. All rights reserved.