Skip to content

Excel Special

The spreadsheets of my life

  • Home
  • Cookie policy (EU)
  • Glossary Term Archives

Dynamic length named range for drop-down list

Posted on 13-02-202016-04-2020 by Tsvetan Georgiev
This entry is part 3 of 7 in the series The gas mon­ey split­ting tool series

Com­bin­ing drop-down list with named range can pro­duce dynam­ic solu­tion for more inter­ac­tive files. With Excel this is easy to make. Read More

CategoriesAdvanced Techniques

Extracting the unique items from a list of entries

Posted on 11-02-202024-12-2020 by Tsvetan Georgiev
This entry is part 2 of 7 in the series The gas mon­ey split­ting tool series

For­mu­las com­pat­i­ble with Excel 2007 and lat­er are used to extract unique val­ues from a list of entries. It is also demon­strat­ed how extra con­di­tions can be added for pre­cise con­trol if the items should be short­list­ed or not. Read More

CategoriesAdvanced Techniques

(Overview) The gas money splitting tool

Posted on 11-02-202016-04-2020 by Tsvetan Georgiev
This entry is part 1 of 7 in the series The gas mon­ey split­ting tool series

An overview of the cal­cu­la­tor prob­lem that is going to be build in the fol­low­ing posts to demon­strate sev­er­al key con­cepts. Read More

CategoriesOthers

3 principles for great spreadsheets

Posted on 05-02-202002-06-2020 by Tsvetan Georgiev

In order to make spread­sheets bet­ter for every­one involved with them, there are many rules to fol­low. 3 of them are Being aware of the end user; Putting prop­er checks; and Avoid­ing hard inputs.

In this post I explain why. Read More

CategoriesSpreadsheet Philosophy
← Newer posts

New post email notification

Loading

Categories

  • Advanced Techniques
  • Basic Techniques
  • Essentials
  • Others
  • Spreadsheet Philosophy
Proudly powered by WordPress