Канал: WesleySon

87.1 - Power Query doesn't load your last columns (use InferSheetDimensions)

87.1 - Power Query doesn't load your last columns (use InferSheetDimensions)

98 - SumIf and F9

98 - SumIf and F9

OnlyUseMeLaser

OnlyUseMeLaser

Standing still (Factorio)

Standing still (Factorio)

82 - Checking palindromes, simple and complicated (Python)

82 - Checking palindromes, simple and complicated (Python)

87 - CSV, deal with variable number of columns (Power Query)

87 - CSV, deal with variable number of columns (Power Query)

97 - List Generate

97 - List Generate

86 - Split columns, varying number of columns (Power Query)

86 - Split columns, varying number of columns (Power Query)

83 - Days between, remove weekends (Power Query)

83 - Days between, remove weekends (Power Query)

81- Aggregate, to e.g. find the next birthday (Excel)

81- Aggregate, to e.g. find the next birthday (Excel)

80 - Recursion in VBA (find the next valid day)

80 - Recursion in VBA (find the next valid day)

79.1 - Python, Weeks to years and months

79.1 - Python, Weeks to years and months

78 - Fixing spelling mistakes, Text Replace vs If (Power Query)

78 - Fixing spelling mistakes, Text Replace vs If (Power Query)

76 - As and Is (Power Query)

76 - As and Is (Power Query)

75 - Recursion in Power Query

75 - Recursion in Power Query

Oops, all ants

Oops, all ants

73 - Making an Excel sheet Very Hidden

73 - Making an Excel sheet Very Hidden

72 - Dynamically updating a title + changing y axis (Power BI)

72 - Dynamically updating a title + changing y axis (Power BI)

71 - Indirect

71 - Indirect

69 - Function scope in Power Query

69 - Function scope in Power Query

64.1 - Time to update a query, pure M

64.1 - Time to update a query, pure M

84 - Storing and accessing metadata, eg count rows of steps (Power Query)

84 - Storing and accessing metadata, eg count rows of steps (Power Query)

68 - Creating a cumulative sum column in Power Query

68 - Creating a cumulative sum column in Power Query

66 - Playing with lists in Power Query

66 - Playing with lists in Power Query

$65 - \d{3} regex in Power Query$

65 - \d{3} regex in Power Query

64 - Use VBA to update queries, and measure the time it took

64 - Use VBA to update queries, and measure the time it took

79 - Function to turn weeks into years and months (Excel, Excel 365 and VBA)

79 - Function to turn weeks into years and months (Excel, Excel 365 and VBA)

Factorio, a train stop with dynamic train limits

Factorio, a train stop with dynamic train limits

Factorio, having a train deposit to multiple stations

Factorio, having a train deposit to multiple stations

79 - Handling a weird data structure (blanks and transpose) (Power Query)

79 - Handling a weird data structure (blanks and transpose) (Power Query)

61 - Using a calculated table as a list of eg definitions

61 - Using a calculated table as a list of eg definitions

57.1 - Mail merge with conditions (Word)

57.1 - Mail merge with conditions (Word)

57.1 - Doing math and using conditional logic in Word

57.1 - Doing math and using conditional logic in Word

60 - Select only tables with X column header (Power Query)

60 - Select only tables with X column header (Power Query)

59 - Inner query (Power Query)

59 - Inner query (Power Query)

56 - Find the max value, always round up and ignore some filters (DAX)

56 - Find the max value, always round up and ignore some filters (DAX)

58 - Using CalculateTable to simulate slicers (DAX)

58 - Using CalculateTable to simulate slicers (DAX)

53 - Print a table, then load it

53 - Print a table, then load it

Uruka loves christmas

Uruka loves christmas

Uruka - Let it snow

Uruka - Let it snow

Uruka - It's beginning to look a lot like christmas (raw)

Uruka - It's beginning to look a lot like christmas (raw)

Uruka - It's beginning to look a lot like christmas (edited)

Uruka - It's beginning to look a lot like christmas (edited)

Uruka - Silver Bells

Uruka - Silver Bells

70 - Alternative methods to replace values in a column

70 - Alternative methods to replace values in a column

67 - Cumulative sum, List Generate and function scope

67 - Cumulative sum, List Generate and function scope

52 - Handling an employee switching departments

52 - Handling an employee switching departments

54 - Arbitrarily shaped filter (and TreatAs)

54 - Arbitrarily shaped filter (and TreatAs)

51 - Dealing with tables with varying column names and number of columns

51 - Dealing with tables with varying column names and number of columns

50 - Countrows on a grouped & filtered table (DAX)

50 - Countrows on a grouped & filtered table (DAX)

47VBA part 3

47VBA part 3

47VBA HoloCure tool, part 2

47VBA HoloCure tool, part 2

Slay the Princess - Stubborn and Undying

Slay the Princess - Stubborn and Undying

47VBA HoloCure tool, part 1

47VBA HoloCure tool, part 1

63 - Fixing the Formula.Firewall-error (Power Query)

63 - Fixing the Formula.Firewall-error (Power Query)

49 - Playing with Summarize and max sales (DAX)

49 - Playing with Summarize and max sales (DAX)

61 - Creating variables in Power Query, using inner queries

61 - Creating variables in Power Query, using inner queries

48 - Playing with Summarize and Groupby (Power Pivot)

48 - Playing with Summarize and Groupby (Power Pivot)

47Python.2 - HoloCure Collabs tool, using python and pandas

47Python.2 - HoloCure Collabs tool, using python and pandas

47Python.1 - HoloCure Collabs tool, using python and pandas

47Python.1 - HoloCure Collabs tool, using python and pandas

46 - Assign type to a new column (Power Query)

46 - Assign type to a new column (Power Query)

47SQL.2 - HoloCure Collabs tool, using Postgres and SQL

47SQL.2 - HoloCure Collabs tool, using Postgres and SQL

55 - Respond to empty meetings (Python)

55 - Respond to empty meetings (Python)

47SQL.1 - HoloCure Collabs tool, using Postgres and SQL

47SQL.1 - HoloCure Collabs tool, using Postgres and SQL

47PowerBI - HoloCure Collabs tool, in Power BI

47PowerBI - HoloCure Collabs tool, in Power BI

47Query - HoloCure Collabs tool, using mostly Power Query

47Query - HoloCure Collabs tool, using mostly Power Query

47Excel.2 HoloCure Collabs tool, using pure Excel (Part 2)

47Excel.2 HoloCure Collabs tool, using pure Excel (Part 2)

47-Excel.1 - HoloCure Collabs tool, using pure Excel (Part 1)

47-Excel.1 - HoloCure Collabs tool, using pure Excel (Part 1)

45 - Cartesian product to get team information for all months (Power Query)

45 - Cartesian product to get team information for all months (Power Query)

43 - Replace values in a column based on conditions

43 - Replace values in a column based on conditions

47 Python.0 - Teaser for HoloCure

47 Python.0 - Teaser for HoloCure

44.5 - Getting the latest and next birthday plus name, and todays birthday girl (Birthday dashboard)

44.5 - Getting the latest and next birthday plus name, and todays birthday girl (Birthday dashboard)

44.4 - Updating measures to make smarter graphs (Birthday dashboard)

44.4 - Updating measures to make smarter graphs (Birthday dashboard)

44.3 - Creating a temporary helper table to visualize a measure (Birthday dashboard)

44.3 - Creating a temporary helper table to visualize a measure (Birthday dashboard)

44.2 - Basic measures (Birthday dashboard)

44.2 - Basic measures (Birthday dashboard)

44.1 - Power Query (Birthday dashboard)

44.1 - Power Query (Birthday dashboard)

41 - Inform the user when there's eg wrong dates

41 - Inform the user when there's eg wrong dates

40 - Grab record given a variable column name (Power Query)

40 - Grab record given a variable column name (Power Query)

39 - Turning one column into a table with filtered columns

39 - Turning one column into a table with filtered columns

42.2 - Combine row 1 and 2 to create the correct column header (List Accumulate)

42.2 - Combine row 1 and 2 to create the correct column header (List Accumulate)

42.1.1 - Combine row 1 and 2 to create the correct column headers, easier

42.1.1 - Combine row 1 and 2 to create the correct column headers, easier

42.1 - Method 1, combine row 1 and 2 to create the correct column headers

42.1 - Method 1, combine row 1 and 2 to create the correct column headers

38 - get top 3 rows when grouping in Power Query

38 - get top 3 rows when grouping in Power Query

37 - Removing duplicates ignores your sort order (Power Query)

37 - Removing duplicates ignores your sort order (Power Query)

36 - User defined function with both sort column AND sort order (Power Query)

36 - User defined function with both sort column AND sort order (Power Query)

31 - Using a record to store multiple values (Power Query)

31 - Using a record to store multiple values (Power Query)

34.2 - Using a table to decide sort order for another table Custom Function (Power Query)

34.2 - Using a table to decide sort order for another table Custom Function (Power Query)

34.1 - Using a table to decide sort order for another table (Power Query)

34.1 - Using a table to decide sort order for another table (Power Query)

29 - Replace the values in a column on a condition (Power Query)

29 - Replace the values in a column on a condition (Power Query)

35 - Dealing with bad dates, using user defined function (Power Query)

35 - Dealing with bad dates, using user defined function (Power Query)

33 - Have your python code run on startup, once per month

33 - Have your python code run on startup, once per month

32 - Wednesday checker + making your python file run on startup (Python)

32 - Wednesday checker + making your python file run on startup (Python)

28 - Coalesce is a simpler way to find the first non-null column (Power Query)

28 - Coalesce is a simpler way to find the first non-null column (Power Query)

25 - Filter a table or list before expansion (Power Query)

25 - Filter a table or list before expansion (Power Query)

24 - Group by and Text Combine in Power Query

24 - Group by and Text Combine in Power Query

30 - Playing with Power BI & Power Pivot

30 - Playing with Power BI & Power Pivot

27.2 - Split a table into tables with 50 rows, via VBA

27.2 - Split a table into tables with 50 rows, via VBA

27.1 - Split a table into tables with 50 rows (Power Query)

27.1 - Split a table into tables with 50 rows (Power Query)

14 - Lock cells to write in Excel (VBA)

14 - Lock cells to write in Excel (VBA)

26 - Combining steps into one step in Power Query

26 - Combining steps into one step in Power Query

23 - Dealing with changing column headers in Power Query

23 - Dealing with changing column headers in Power Query

22 - Adding a row to a table in Power Query

22 - Adding a row to a table in Power Query

21 - Grab URL and title from all browser tabs (Power Automate Desktop)

21 - Grab URL and title from all browser tabs (Power Automate Desktop)

20 - 5 methods to load/create tables in Power Query

20 - 5 methods to load/create tables in Power Query

19 - Archive rows (VBA)

19 - Archive rows (VBA)

18 - Archive table(s) with Power Query (Excel)

18 - Archive table(s) with Power Query (Excel)

17 - Extract course information & do math (PAD/Power Query)

17 - Extract course information & do math (PAD/Power Query)

16 - Checking reading time and difficulty Power Automate Desktop

16 - Checking reading time and difficulty Power Automate Desktop

15 - Power Query, smarter error handling in the last step (Excel)

15 - Power Query, smarter error handling in the last step (Excel)

13 - Dealing with variable column names in Power Query (Excel)

13 - Dealing with variable column names in Power Query (Excel)

12 - Using RegEx in Excel (VBA)

12 - Using RegEx in Excel (VBA)

11 - Creating an adaptive dropdown-menu in Excel

11 - Creating an adaptive dropdown-menu in Excel

10 - Count duplicates (Power Query/Pivot table/VBA)

10 - Count duplicates (Power Query/Pivot table/VBA)

09 - Count unique rows (VBA)

09 - Count unique rows (VBA)

08 - Count unique rows (Power Query)

08 - Count unique rows (Power Query)

07 - Filter a table using a variable (VBA)

07 - Filter a table using a variable (VBA)

06 Hide worksheets on close (VBA)

06 Hide worksheets on close (VBA)

04 PAD - Checking when the last Chainsaw Man chapter was released

04 PAD - Checking when the last Chainsaw Man chapter was released

05 Excel VBA - Loop and write letters

05 Excel VBA - Loop and write letters

02 - Power Automate Desktop plays Bloons TD6

02 - Power Automate Desktop plays Bloons TD6

01 Using Power Automate to log on to your Runescape account

01 Using Power Automate to log on to your Runescape account

03 Excel - Making an Extra-Hidden sheet

03 Excel - Making an Extra-Hidden sheet

0 On Action vs Motion

0 On Action vs Motion