happy new year2

2013 is almost over. Here is a list of the 5 most visited blog posts 2013, written 2013.

  1. Copy / Rename a file (excel vba)

    Learn more about file copying techniques in excel using visual basic for applications.

  2. Custom data labels in a chart

    Quickly change data label values without editing the chart. No visual basic required.

  3. Lookup multiple values in one cell (vba)

    A custom function that looks up multiple values in a single cell, separated by a delimiting character.

  4. Dynamic data labels in a chart

    This blog article demonstrates how to change data labels in a scatter chart depending on a drop down list value.

  5. Heat map calendar

    A calendar that has colored dates depending on how busy they are.

Here is a list of the 5 most visited blog posts 2013, written 2012.

  1. Use multiple conditions in Vlookup

    An introduction to the VLOOKUP function and advanced examples. How to use criteria and a table in the function arguments and finally a more useful technique than the VLOOKUP function.

  2. Lookup multiple values in different columns and return a single value

    Learn more advanced formula techniques.

  3. How to use a table name in data validation lists and conditional formatting formulas

    Learn how to use excel defined table names in drop down lists and conditional formatting formulas.

  4. Apply data validation lists dynamically (vba)

    Two examples of automatically copying drop down lists in an excel sheet.

  5. Run a macro from a drop down list (vba)

    Not much to say about this one.

I wish you all a happy new year!