Excel Magic Trick 1328: Case Sensitive Filtering, Adding or Counting: Power Query (Get & Transform)

preview_player
Показать описание
Download Excel Files:

See how to:
1. (00:17) Introduction to Formulas for Counting and Adding with Case Sensitive Criteria
2. (00:55) Power Query (Get & Transform) and Converting Proper Data Set to an Excel Table
3. (01:38) Excel Filtering is NOT Case Sensitive
4. (02:11) Power Query (Get & Transform) Filtering IS Case Sensitive
5. (03:23) Power Query (Get & Transform) to Counting with Case Sensitive Criteria
6. (05:28) Power Query (Get & Transform) to Add with Case Sensitive Criteria
  1. excelisfun
  2. Excel
  3. Microsoft Excel
  4. Highline College
  5. Mike Girvin
  6. excelisfun
Рекомендации по теме
Excel Magic Trick 0:06:55

Excel Magic Trick 1328: Case Sensitive Filtering, Adding or Counting: Power Query (Get & Transfo...

Excel Magic Trick 0:12:33

Excel Magic Trick 1329: Clean Data Then Add w 2 Criteria: SUMIFS or Power Query (Get & Transform...

Excel Magic Trick 0:24:51

Excel Magic Trick 1326: Conditionally Format Text Modes: PivotTable, Array Formula or Power Query?

Excel Magic Trick 0:04:21

Excel Magic Trick 1327: Formula to Count Words in Column with Mixed Data: COUNTIFS Function

Excel Magic Trick 0:10:31

Excel Magic Trick 1339: Create Alphabet A – Z: Formula, Power Query, or Custom List?

Excel Magic Trick 0:08:03

Excel Magic Trick 1317: Formulas for Total Insulin Units… And Excel’s Golden Rule & MAX Replaces...

Excel Magic Trick 0:10:08

Excel Magic Trick 1031: Four Way Lookup Formula To Deliver Multiple Items From 1 of 2 Lookup Tables

Case Sensitive Lookup 0:02:07

Case Sensitive Lookup in Any Version of Excel. Excel Magic Trick 1772

Excel Magic Trick 0:08:25

Excel Magic Trick 1312: Count The Number Of Mondays & Tuesdays Since Birth: NETWORKDAYS.INTL

Excel Magic Trick 0:06:38

Excel Magic Trick 1340: Create Expandable Range in an Excel Table (2 Methods)

Excel Magic Trick 0:07:35

Excel Magic Trick 1301: Sorted List of Modes in Single Cell with TEXTJOIN Array Formula

Ignoring Case and 0:00:58

Ignoring Case and Removing Duplicates in Power Query

Excel Magic Trick 0:06:13

Excel Magic Trick 1320: Distinct/Unique Count with 1 Condition using Power Query (Get & Transfor...

Counting Data by 0:02:41

Counting Data by Case Sensitive Criteria in MS Excel

Excel Magic Trick 0:30:37

Excel Magic Trick 1322: Backwards One To Many Relationship Report: Excel, Power Query or SQL?

compare two columns 0:01:31

compare two columns in excel case sensitive - excel: compare 2 columns using Exact function

Perform a Case 0:10:52

Perform a Case Sensitive Filter in Excel

Excel Magic Trick 0:26:42

Excel Magic Trick 1321: Time Between Starting College & Taking 1st Geology Class (6 Methods)

#40 Case Sensitive 0:01:19

#40 Case Sensitive Sorting in excel.

PBI Table.FindText 0:00:57

PBI Table.FindText

ExcelIsFun answer 0:08:41

ExcelIsFun answer

Excel 2013 PowerPivot 0:08:21

Excel 2013 PowerPivot Basics #13: Replace 3 Way Lookup Array Formulas for 1.2 Million Rows of Data

Top 05 Microsoft 0:05:17

Top 05 Microsoft Excel Tricks & Hacks Tools Must Watch

iroc Tiayra Reidnauer 0:04:21

iroc Tiayra Reidnauer

Комментарии
Автор

Loving your videos. Do you have one where you have a master sheet where the first x number of cols are repeated throughout every sheet and I can add specific cols for the rest? If you add a row to the master it will add to the row to the others. Thanks.

CyanidePierce
Автор

In this video we have learned to count or sum a single column. How can we sum multiple columns e.g., daily sales of a week using Power Query?

zaighamuddinfarooqui
Автор

Ok, how I can do the same thing non case sensitive using power query?

vladimirkosimovsky