User Defined Functions

This repository brings together a set of user-defined functions (UDFs) developed for VBA and Power Query (M), with the goal of extending the native capabilities of Excel and Power BI. Here you will find both functions created by me and useful functions developed by others — always properly organized, documented, and referenced.

🎯 Objective

• To centralize, organize, and facilitate access to a catalog of reusable functions, allowing:
• To accelerate the development of solutions in Excel, Power Query, and Power BI.
• To maintain a versioned and easily searchable repository.
• To reuse functions tested and validated in different contexts.

Table of Contents

M Code (Power Query)

Function	Documentation
Binary.Unzip	📄
DateTime.ToUnixTime	📄
Decision.EntropyWeights	📄
Decision.TOPSIS	📄
List.Correlation	📄
List.Intercept	📄
List.Outliers	📄
List.PopulationStdDev	📄
List.Primes	📄
List.Rank	📄
List.Slope	📄
List.Variance	📄
List.WeightedAverage	📄
Number.FromRoman	📄
Number.IsInteger	📄
Number.IsPrime	📄
Number.ToRoman	📄
Statistical.NormDist	📄
Statistical.NormInv	📄
Table.AddColumnFromList	📄
Table.CorrelationMatrix	📄
Table.FixColumnNames	📄
Table.PreprocessTextColumns	📄
Table.RemoveBlankColumns	📄
Table.TransposeCorrectly	📄
Text.CountChar	📄
Text.ExtractNumbers	📄
Text.HtmlToPlainText	📄
Text.RegexExtract	📄
Text.RegexReplace	📄
Text.RegexSplit	📄
Text.RegexTest	📄
Text.RemoveAccents	📄
Text.RemoveDoubleSpaces	📄
Text.RemoveLetters	📄
Text.RemoveNumerals	📄
Text.RemovePunctuations	📄
Text.RemoveStopwords	📄
Text.RemoveWeirdChars	📄

VBA (Visual Basic Application)

Function	Documentation
AreArraysEquals	📄
AutoFillFormulas	📄
CleanString	📄
DisableRefreshAll	📄
EnableRefreshAll	📄
CleanString	📄
FileNameIsValid	📄
GetAllFileNames	📄
GetLettersOnly	📄
GetMonthNumberFromName	📄
GetStringBetween	📄
GetStringWithSubstringInArray	📄
GetTableColumnNames	📄
IsAllTrue	📄
IsInArray	📄
ListObjectExists	📄
PreviousMonthNumber	📄
RangeHasAnyFormula	📄
RangeHasConstantValues	📄
RangeIsHidden	📄
RangeToHtml	📄
SendEmail	📄
SetQueryFormula	📄
StringContains	📄
StringEndsWith	📄
StringStartsWith	📄
SubstringIsInArray	📄
Summation	📄
TableHasQuery	📄
WorksheetHasListObject	📄

🤝 Contributions

Contributions are welcome! If you have an interesting feature, improvement, or fix for any function or documentation, feel free to open a pull request or an issue.

🗂️ Other UDF Repositories

Here is a list of very useful repos of user-defined functions:

• M by Imke Feldmann
• M Custom Functions by Štěpán Rešl
• m-custom-functions by Tirnovar
• M-tools by Kim Burgess
• PowerBi-code by ibarrau
• PowerQueryFunctions by OscarValerock
• PowerQueryLib by NinMonkey