Objects tagged with excel


← Back to the Posts

Use a Table Column as a List in a Validation List

Published on April 18, 2017 at 07:07AM

This is easy to do but not as easy as you would first think.

Boilerplate Excel VBA Functions module

Published on February 15, 2017 at 05:59AM

A basic module I load to each project for shared functionality

Single and Multi Line Comments in Power Query Advanced Editor

Published on February 13, 2017 at 11:01AM

Just a simple reminder on how to do single and multiple line comments

Countif in Power Query or Powerbi using M Language

Published on February 13, 2017 at 10:57AM

You know how to countif in Excel so why is Power Query so difficult?

Get Row Number in Worksheet in Excel Using VBA

Published on February 13, 2017 at 10:54AM

A simple function to return the row number of a table where a value is matched in a column. Like a VLOOKUP or INDEX MATCH for VBA.