1. Welcome to Chandoo.org Forums. Short message for you

    Hi Guest,

    Thanks for joining Chandoo.org forums. We are here to make you awesome in Excel. Before you post your first question, please read this short introduction guide. When posting or responding to questions please remember our values at Chandoo.org are: Humility, Passion, Fun, Awesomeness, Simplicity, Sharing Remember that we have people here for whom English is not there first language and we need to allow for this in our dealings.

    Yours,
    Chandoo
  2. 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...

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

Popular and Useful Forum Posts

Discussion in 'The Vault' started by Hui, Jun 11, 2013.

Thread Status:
Not open for further replies.
  1. Hui

    Hui Excel Ninja Staff Member

    Messages:
    10,280
    Please find below a list of Popular and Useful Forum Posts
    These are compiled from contributions by the Excel Ninja's

    =========================================

    Concatenate a Range of Cell's includes ConcatIf a condition
    http://chandoo.org/wp/2008/05/28/how-to-add-a-range-of-cells-in-excel-concat/

    Get cell color/ Use cell color in Conditional Formatting
    http://chandoo.org/forum/threads/how-to-identify-background-color-of-a-cell-with-a-formula.6833/

    Extract Formulas from a File
    http://chandoo.org/forum/threads/how-to-extract-all-formulas-used-in-an-excel-file.4505/

    VLookup returning Multiple values
    http://chandoo.org/forum/threads/vlookup-to-return-multiple-corresponding-values.3030/

    Advanced Filter:
    Move Data to other Sheets
    http://chandoo.org/wp/2012/05/14/vba-move-data-from-one-sheet-to-multiple-sheets/
    Advanced Filter Move Data to other Files
    http://chandoo.org/wp/2011/10/19/split-excel-file-into-many/

    Repair a Broken/Corrupt File
    http://chandoo.org/forum/threads/problems-with-xlsb-format.11006/

    Lookup and summarise a range based on Criteria
    Single Criteria
    http://chandoo.org/wp/2011/11/18/formula-forensics-003/
    Multiple Criteria
    http://chandoo.org/wp/2014/11/10/formula-forensics-no-003b-lukes-reward-part-ii/

    Translate Excel Formulas to Other Languages
    http://chandoo.org/forum/threads/excel-multilanguage-formula-translator-and-function-reference.4789/

    Learn Excel
    http://chandoo.org/wp/2012/01/06/12-ways-to-learn-excel/
    http://chandoo.org/forum/threads/what-excel-books-members-are-reading-recommend.12308/#post-73814

    Print Multiple Pages
    http://chandoo.org/wp/2011/09/14/hui’s-excel-report-printer/
    http://forum.chandoo.org/threads/print-macro-for-selected-sheets-from-200-worksheets.5795/
    http://chandoo.org/forum/threads/print-areas.18184/

    Sumproduct
    http://chandoo.org/wp/2009/11/10/excel-sumproduct-formula/
    http://www.excelhero.com/blog/2010/01/the-venerable-sumproduct.html
    http://chandoo.org/wp/2011/12/21/formula-forensics-no-007/
    http://chandoo.org/wp/2011/05/26/advanced-sumproduct-queries/

    Convert Numbers to Text
    http://forum.chandoo.org/threads/how-to-convert-numbers-to-text.2321/

    Find the PC's IP Number
    http://chandoo.org/forum/threads/wh...eads-and-book-marks-from-the-old-forum.18518/

    Trendlines
    http://chandoo.org/wp/2011/01/24/trendlines-and-forecasting-in-excel/
    http://chandoo.org/wp/2011/01/26/trendlines-and-forecasting-in-excel-part-2/
    http://chandoo.org/wp/2011/01/27/trendlines-and-forecasting-in-excel-part-3/

    Montecarlo Simulation & Data Tables
    http://chandoo.org/wp/2010/05/06/data-tables-monte-carlo-simulations-in-excel-a-comprehensive-guide/

    Dynamic Drop down Lists
    Recently Jeffrey Weir has written a post on this, check it out here:
    http://chandoo.org/wp/2014/02/13/dynamic-cascading-dropdowns-that-reset/
    http://chandoo.org/wp/2014/02/25/robust-dynamic-cascading-dropdowns-without-vba/

    Combine Files from a Directory
    https://support.office.com/en-us/article/Power-Query-Combine-Binaries-94b8023c-2e66-4f6b-8c78-6a00041c90e4
    Last edited: Jan 30, 2017
  2. Luke M

    Luke M Excel Ninja

    Messages:
    9,252
  3. Faseeh

    Faseeh Excel Ninja

    Messages:
    2,657
    I find following useful and often repeatedly asked questions:

    Using Excel to analyze and find largest surplus in inventory with multiple location
    http://chandoo.org/forum/threads/us...urplus-in-inventory-with-multiple-locat.2863/

    Converting numbers to Time
    http://chandoo.org/forum/threads/converting-numbers-to-time-solved.10626/

    Countifs with Wild Card
    http://chandoo.org/forum/threads/countifs-with-wild-card.9925/

    Price as per quantity
    http://chandoo.org/forum/threads/price-as-per-quantity.9780/

    Formula to calculate commission based on sliding scale
    http://chandoo.org/forum/threads/formula-to-calculate-commission-based-on-sliding-scale.9464/
    Narend likes this.
  4. Abhijeet R. Joshi

    Abhijeet R. Joshi Active Member

    Messages:
    269
  5. shrivallabha

    shrivallabha Excel Ninja

    Messages:
    1,591
Thread Status:
Not open for further replies.

Share This Page