• 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

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

Plot Non-Contiguous Data
https://chandoo.org/wp/2012/12/04/f...ting-dynamic-charts-with-non-contiguous-data/
https://chandoo.org/forum/threads/d...rray-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/i...les-to-excel-with-semi-colon-delimiter.37514/
https://chandoo.org/forum/threads/h...me-in-the-active-worksheet-using-macro.37896/
 
Last edited:
Here's my list of "go-to" articles:

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

Remove workbook/worksheet/VBA passwords
http://chandoo.org/forum/threads/remove-password.23208/

Explanation of Array formulas
http://chandoo.org/forum/threads/plain-language-definition-of-array-formulas-vs-other-formulas.3910/

Build a WBS outline
http://chandoo.org/forum/threads/macro-vba-for-grouping-outline-of-wbs-structure.21437/#post-129504

Count Unique entries w/ Criteria(s)
http://chandoo.org/forum/threads/combine-countifs-and-unique-function.2871/

Calculate working hours:
http://chandoo.org/forum/threads/working-days-and-hours-only.12185/#post-71438

Page numbering
Http://chandoo.org/forum/threads/macro-to-return-page-number-of-a-named-cell.9787/

How to create list of items meeting criteria:
http://chandoo.org/wp/2011/11/18/formula-forensics-003/
 
Last edited by a moderator:
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/
 
Last edited by a moderator:
Last edited by a moderator:
 
Last edited by a moderator:
Here is the list I found useful and frequently asked:

INDEX: An alternative to array (CSE) formulas:
https://excelxor.com/2014/09/01/index-an-alternative-to-array-cse-formulas/

MAXIF Non Array:
https://www.excelforum.com/tips-and-tutorials/817784-maxif-without-using-an-array-formula.htm

COUNTIF / SUMIF with OR Criteria:
https://excelxor.com/2014/09/28/cou...eria-for-one-or-two-criteria_ranges/#more-926

Sorting a List Alphabetically (Without Filters)
https://excelxor.com/2015/01/22/sorting-a-list-alphabetically-without-filters/#more-4166

AGGREGATE:
https://www.sumproduct.com/thought/aggregate

Excel Tables:
https://chandoo.org/wp/2018/01/11/this-year-become-a-very-table-genius/

Split Delimited Text using formula:
https://chandoo.org/forum/threads/hashtag-separation.26690/#post-159555

Regards,
 
 
Last edited:
You must log in or register to reply here.
Back
Top