Excel Magic Trick 1392: Case Sensitive Unique Count: Power Query or Data Model PivotTable?

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

See how to perform Case Sensitive Unique Count with Power Query:

1. (00:15) Introduction and examples of Remove Duplicates ans Data Model PivotTable Disnict Count Function will not perform Case Sensitive Unique Count.
2. (01:34) Case Sensitive Unique Count with Power Query
  1. excelisfun
  2. Excel
  3. Microsoft Excel
  4. Highline College
  5. Mike Girvin
  6. excelisfun
Рекомендации по теме
Excel Magic Trick 0:03:56

Excel Magic Trick 1392: Case Sensitive Unique Count: Power Query or Data Model PivotTable?

Excel Magic Trick 0:14:35

Excel Magic Trick 1391: Case Sensitive VLOOKUP? 5 Examples of Excel Case Sensitive Lookup

Excel Magic Trick 0:28:32

Excel Magic Trick 1387: Data Model & DAX Formulas: Quantity Frequency Distribution by Year &...

Excel Magic Trick 0:05:13

Excel Magic Trick 1394 Part 2: Formulas for % Parent Total using Wild Cards to Get First Text Item

Excel Magic Trick 0:19:28

Excel Magic Trick 1397: Excel Count Formulas for Running Total and % of Running Total & Ogive Ch...

Excel Magic Trick 0:10:51

Excel Magic Trick 1400: Conditionally Format Row in Class Enrollment Table with Complex Criteria

Excel Magic Trick 0:06:15

Excel Magic Trick 1386: Power Query to Import & Append Large Text File in Power Pivot Data Model

Excel Magic Trick 0:04:00

Excel Magic Trick 1384: Import Excel Table or Sheet in Power Query or Power BI?

Excel Magic Trick 0:11:08

Excel Magic Trick 1396: PivotTable Show Values As: Running Total and % of Running Total (2 Examples)

Excel Magic Trick 0:19:34

Excel Magic Trick 1400 Part 2: Conditionally Format Row with Complex Criteria (3 More Examples)

Excel Magic Trick 0:55:04

Excel Magic Trick 1375 Add w OR Logical Test from 2 Different Columns in 2 Diff. Tables (6 Examples)

Excel Magic Trick 0:16:33

Excel Magic Trick 1394: Excel Formulas for: % Column Total, % Parent Total, % Parent Row Total

How to extract 0:12:21

How to extract a case sensitive unique distinct list [Formula]

How To Do 0:04:03

How To Do A Case Sensitive XLOOKUP In Excel

Is Data Validation 0:06:37

Is Data Validation case sensitive for lists?

Perform a Case 0:10:52

Perform a Case Sensitive Filter in Excel

How To Filter 0:01:20

How To Filter Cells With Case Sensitive In Excel?

Case Insensitive Lookup 0:07:51

Case Insensitive Lookup with Power Query

CONTAINSSTRING vs CONTAINSSTRINGEXACT 0:09:57

CONTAINSSTRING vs CONTAINSSTRINGEXACT in Power BI

35 - Find 0:11:16

35 - Find Maximum Value by Criteria in Excel

Case Insensitive Filtering 0:01:41

Case Insensitive Filtering Using Power Query or Get & Transform From Power BI

MBA633 AD SREG04 0:14:17

MBA633 AD SREG04

Index & Match 1:08:14

Index & Match Function with Examples (Basic to Advanced)

Find Duplicate Entries 0:03:58

Find Duplicate Entries in Excel

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

Case sensitive distinct count with PQ is great stuff! On a less sensitive note, what I learned from Jordan Goldmeier is you should try to name your table names/defined names in an object oriented format as in [sheet name.defined name]Sheet1.tNames because it will make it easier for you to know where your referenced data is coming especially if you have lots of formulas that utilize defined names.

Sal_A
Автор

Power query. the more I use it the more I like it. Thanks, Mike

eCabinetstipsandtricks
Автор

wow! so easy to solve this with Power Query! Interesting how the remove duplicates feature in PQ works (case sensitive). thanks Mike

MySpreadsheetLab
Автор

PQ is most useful and powerful feature. However its credit goes to you "Mr. Magician" who had made it friendly for us, otherwise it was a "monster". :D

zaighamuddinfarooqui
Автор

Why can't we simply sort the data by using the Proper formula and then highlighting or removing duplicate values?
That would be much simpler, wouldn't it?

ahamsahastramee