Codes recently updated

New versions for codes, updated recently by our developers. 24 most recent codes.
v3
{{$CodeName$}
MathInsideText

Return string after applying math to each number found inside the string. ...

Thu 5PM

v2
{{$CodeName$}
FilesIn_Array and FoldersIn_Array

Return list of files in a folder back as array. Similar to

May17

v2
{{$CodeName$}
ImagesIn_Count

Counts number of image files found in a folder Images defined here are files ...

May15

v2
{{$CodeName$}
AddDatabar_ConditionalFormatting

Adds databars conditional formatting to range of cells. Passing column, start ...

May15

v2
{{$CodeName$}
ANmaCellChar_Superscript_Subscript

Sets certain character inside a cell as superscript or subscript Edit ...

May15

v2
{{$CodeName$}
CountRowCells

Counts how many cells with data in a row, starting from certain column until ...

May12

v3
{{$CodeName$}
Match3_3rdNot0

Searches for two cells in two columns then checks for 3rd column if not equal ...

May12

v4
{{$CodeName$}
Match4_4thNot0

Searches for three cells in three columns then checks for 4th column if not ...

May12

v3
{{$CodeName$}
MatchIf2Up

Search for 2 items in 2 columns starting from last row upword (Starting with ...

May12

v3
{{$CodeName$}
MatchIfUp or MatchIfRev

Searching for an item in a column from bottom to top. Will search for item in ...

May12

v2
{{$CodeName$}
MatchIf5Up

Searches for five cells in five columns and return the row number if all found ...

May12

v3
{{$CodeName$}
MatchIF5

Searching for rows having 5 values in 5 columns Like

May12

v2
{{$CodeName$}
Column1Range

Return range of cells in column having data where, ignoring header cell and ...

May11

v2
{{$CodeName$}
MatchIf6Up

Searches for 6 values in 6 columns and return the row number found in. ...

May11

v2
{{$CodeName$}
MatchIf6

Searching for row have 6 matches found in 6 different columns, because we had 5, ...

May11

v5
{{$CodeName$}
NumberBeforeString_HTML

Cuts a number that would be found before certain word inside a block string. ...

May6

v2
{{$CodeName$}
NumberBeforeString_HTML2

Cuts a number that would be found 2 words before certain word inside a block ...

May6

v6
{{$CodeName$}
ANmaRedirect

Simple redirecting function, used to direct users from one domain into another ...

Apr24

v3
{{$CodeName$}
ContainerHTMLTag_ReturnBlock

Returns the full string starting from open tag of container where LocationIndex ...

Apr14

v9
{{$CodeName$}
HTMLPadding_v2

Finds the padding or margin from a style statement for an HTML tag. Passing ...

Apr12

v3
{{$CodeName$}
CutString9

Cuts from CutFrom starting from any of items found from ...

Apr10

v2
{{$CodeName$}
TemplateLine_10Xs

Two functions to automate the replacing of variables inside a long string. Up ...

Apr10

v2
{{$CodeName$}
CopyRange_NoClipboard

Copies range without using clipboard. Applies formats into a cell (or range) ...

Mar13

v2
{{$CodeName$}
Min_No0s

Getting the minimum number from an array excluding zeros. Edit 2025-03-11: ...

Mar11