Excel Magic Trick 1328

Case Sensitive Filtering, Adding or Counting: Power Query (Get & Transform)

DESCRIPTION

See how to:
(00:17) Introduction to Formulas for Counting and Adding with Case Sensitive Criteria
(00:55) Power Query (Get & Transform) and Converting Proper Data Set to an Excel Table
(01:38) Excel Filtering is NOT Case Sensitive
(02:11) Power Query (Get & Transform) Filtering IS Case Sensitive
(03:23) Power Query (Get & Transform) to Counting with Case Sensitive Criteria
(05:28) Power Query (Get & Transform) to Add with Case Sensitive Criteria

WORKBOOKS

Download “Excel Magic Trick 1321-1340” Excel-Magic-Trick-1321-1340.zip – Downloaded 259 times – 98 MB




Be the first to comment

Leave a Reply