• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Search results

  1. K

    Extracting Data from a Table and Summing

    I have this table of data with column headers as follows..."School Code", "ISBN", "Cost",etc...Is there a formula or combination that will (1) extract all the ISBN's for a particular "School Code", then (2)Multiply each extracted record by its associated cost? I am trying to avoid pivot tables...
  2. K

    Updating links when tabs are renamed

    Is there a quick and simple way to update the links between workbooks when the linked tab in the source workbook is moved and/or renamed.
  3. K

    Sumifs Formula to extract data based on 2 fiscal periods.

    I am attempting to retrieve data based on "service dates" prior to July 2010 and dates in July 2010 or later. Results for each of these periods will be placed in cells A1 &B1. However, because the fiscal year runs from July 10-June 11, i can foresee a problem when January 11 comes around as data...
  4. K

    Index and Match Function

    Will this function work with an array that contain duplicate values?
  5. K

    Data comparison between two tables?

    how to display data or values contained in one table but not another?
Back
Top