excel magic trick 1328: case sensitive filtering, adding or counting: power query (get & transform)
Published 7 years ago • 8K plays • Length 6:55Download video MP4
Download video MP3
Similar videos
-
3:56
excel magic trick 1392: case sensitive unique count: power query or data model pivottable?
-
12:33
excel magic trick 1329: clean data then add w 2 criteria: sumifs or power query (get & transform)?
-
24:51
excel magic trick 1326: conditionally format text modes: pivottable, array formula or power query?
-
9:18
power query - filter table based on distinct not conditions from list - excel magic trick 1592
-
11:21
excel magic trick 1263: power query m code: 10 cross tabulated transformed into 1 proper data set
-
1:34
excel magic trick 1358: query dependencies view in power query (get & transform)
-
2:07
case sensitive lookup in any version of excel. excel magic trick 1772
-
10:41
excel magic trick 1243: transform gdp data set: power query 2nd method or advanced filter?
-
6:38
excel magic trick 1340: create expandable range in an excel table (2 methods)
-
8:21
excel 2013 powerpivot basics #13: replace 3 way lookup array formulas for 1.2 million rows of data
-
7:35
excel magic trick 1301: sorted list of modes in single cell with textjoin array formula
-
10:31
excel magic trick 1339: create alphabet a – z: formula, power query, or custom list?
-
4:16
excel magic trick 1315: create a unique sorted list with power query