Skip to content

Excel Special

The spreadsheets of my life

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

Category: Advanced Techniques

This cat­e­go­ry offers detailed tuto­ri­als on how to per­form spe­cif­ic task by employ­ing approach­es beyond the basics. Pic­tures and addi­tion­al files are to be expect­ed along­side the comments.

Finding similar items in Excel based on their properties

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

You can find sim­i­lar items in Excel based on their under­ly­ing prop­er­ties. Run­ning shoes are used to show how to approach the prob­lem and con­struct an array for­mu­la that gets the job done. Read More

CategoriesAdvanced Techniques

Excel =LOOKUP() with conditions

Posted on 17-04-202017-04-2020 by Tsvetan Georgiev
This entry is part 5 of 7 in the series The gas mon­ey split­ting tool series

The =LOOKUP() func­tion in Excel can return val­ue from a vec­tor that sits against an exact/approximate match in anoth­er one. Flex­i­bil­i­ty can be added in the for­mu­la by employ­ing a con­di­tion whether some vec­tor ele­ments to be used or not. Read More

CategoriesAdvanced Techniques, Basic Techniques

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

New post email notification

Loading

Categories

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