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

Popular and Useful Excel Posts

Hui

Excel Ninja
Staff member
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/where-to-find-our-old-threads-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

Plot Non-Contiguous Data
https://chandoo.org/wp/2012/12/04/formula-forensics-no-032-creating-dynamic-charts-with-non-contiguous-data/
https://chandoo.org/forum/threads/dynamically-generate-contiguous-data-in-array-for-chart-from-non-contiguos-range.7683/

Import CSV and other file types
https://chandoo.org/forum/threads/import-text-file-kml-…-xml.37429
https://chandoo.org/forum/threads/import-multiple-csv-files-to-excel-with-semi-colon-delimiter.37514/
https://chandoo.org/forum/threads/how-to-read-data-from-a-csv-file-and-write-the-same-in-the-active-worksheet-using-macro.37896/
 
Last edited:

Faseeh

Excel Ninja
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/using-excel-to-analyze-and-find-largest-surplus-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/
 
Last edited by a moderator:
Top